Command Line Options for /schemacompare Operation

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 a 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 comparsion
IgnoreCheckConstraints icheck Ignore check constraints
IgnoreCollations icollate Ignore collations
IgnoreColumnDefaultValues icolumndef Ignores column default values during comparison
IgnoreColumnOrderInIndexes icolumnordind Ignore column order in indexes
IgnoreComments icomm Ignore comments
IgnoreCommentsOptions icommopt Ignore commnet 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 Ignode 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 Ingore 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 synchdonization
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
MappingIgnoreSpaces mispace Ignore spaces 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