Command Line Options for /schemacompare

Last modified: February 7, 2025

By default, dbForge Studio for MySQL generates a file with command line arguments and writes all the comparison and synchronization options into it. Each option is written like the following:

/option_name: [Y/N]

You can edit the file to turn on/off required options. To turn on comparison and synchronization options, edit their values to Yes, Y, True, T, or On. To turn off the options, change their values to No, N, False, F, or Off.

Each option has a full and short name. You can type either name of the required option into Command Prompt instead of editing the file.

See the list of the options with their full and short command line names below.

Command line option name	Short name	Option
CheckObjectExistence	chkobjex	Check for object existence
DisableDependencyAnalysis	disdep	Disable dependency analysis
DropCreateOnly	dropcreateonly	Use DROP and CREATE instead of ALTER
DropCreateOnlyTables	dropcreateonlyt	Use DROP and CREATE instead of ALTER for tables
ExcludeComments	nocomments	Exclude comments
ForceColumnOrder	force	Force column order
IgnoreAutoIncrement	iautoinc	Ignores auto increment table property during comparison
IgnoreAvgRowLength	iavgrowlen	Ignores average row length property during comparison
IgnoreCase	icse	Ignore case during comparison
IgnoreCheckConstraints	icheck	Ignore check constraints
IgnoreCollations	icollate	Ignore collations and character sets
IgnoreColumnDefaultValues	icolumndef	Ignores column default values during comparison
IgnoreColumnOrderInIndexes	icolumnordind	Ignore column order in indexes
IgnoreComments	icomm	Ignore comments
IgnoreCommentsOptions	icommopt	Ignore comments options
IgnoreConstraintsNames	icnames	Ignore constraint names
IgnoreDataTypesInColumn	idtc	Ignore data types in column
IgnoreDefiner	idefiner	Ignores DEFINER and SQL SECURITY clauses during comparison
IgnoreDropIndexes	idropi	Ignore indexes present only in Target
IgnoreDropTriggers	idropt	Ignore DML and INSTEAD OF triggers present only in Target
IgnoreEndsClause	iends	Ignores ENDs clause in event definition
IgnoreForeignKeyActions	ifkacts	Ignore foreign keys actions ON UPDATE and ON DELETE
IgnoreForeignKeys	ifk	Ignores foreign keys during comparison
IgnoreFullTextIndexes	iftindex	Ignore full-text indexes
IgnoreIndexesNames	iinames	Ignore index names
IgnoreNotNullConstraints	inotnullc	Ignore NOT NULL constraints
IgnorePartitions	ipart	Ignore partitions
IgnorePermissions	iperm	Ignore permissions
IgnorePrimaryKeys	ipk	Ignore primary keys
IgnoreSpatialIndexes	ispindex	Ignore spatial indexes
IgnoreStartsClause	istarts	Ignores STARTS clause in event definition
IgnoreSynonymForFunctions	ifuncsyn	Ignore synonyms for functions
IgnoreTableDMLTriggers	itdmltrig	Ignore table DML triggers
IgnoreTableEngine	iengine	Ignores table engine types during comparison
IgnoreTriggerFireOrder	ifire	Ignore firing order for DML triggers
IgnoreWhiteSpace	ispace	Ignore differences in white spaces during comparison and synchronization
IgnoreSequencesMinValue	iseqmv	Ignore MIN VALUE in sequences and identity column during comparison and synchronization
IgnoreSequencesCycle	iseqcycle	Ignore CYCLE in sequences and identity column during comparison and synchronization
IgnoreSequencesIncrementBy	iseqinc	Ignore INCREMENT BY in sequences and identity column during comparison and synchronization
IgnoreSequencesInitials	iseqst	Ignore START WITH in sequences and identity column during comparison and synchronization
IgnoreSequencesMaxValue	iseqmxv	Ignore MAXVALUE in sequences and identity column during comparison and synchronization
IgnoreSequencesCache	iseqcache	Ignore CACHE in sequences and identity column during comparison and synchronization
IncludeComparisonSettings	incsettings	Includes comparison settings into your report
IncludeIdenticalObjects	incident	Includes identical objects into your report
IncludeUseDatabase	inud	Include USE / clause to the script
MappingIgnoreCase	micase	Ignore case in object names when mapping them
MappingSimilar	msim	Associate column names having similar name options
SelectedObjectsOnly	selobjonly	Includes objects selected for synchronization into your report