By default, dbForge Schema Compare 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 |
---|---|---|
AffectedFileReadOnly | affectedfile | Remove the read-only attribute from the affected files |
CheckObjectExistence | cexist | 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 |
ExcludeDependencies | edep | Exclude dependencies |
ForceColumnOrder | force | Force column order |
IgnoreAutoIncrement | iautoinc | Ignore AUTO_INCREMENT clause |
IgnoreAutoIncrementDefinition | iautoincremdef | Ignore AUTO_INCREMENT table option |
IgnoreAvgRowLength | iavgrowlen | Ignore average low length |
IgnoreCheckConstraints | icheck | Ignore check constraints |
IgnoreCollations | icollate | Ignore collations |
IgnoreColumnDefaultValues | icolumndef | Ignore column default values |
IgnoreColumnOrderInIndexes | icolumnordind | Ignore column order in indexes |
IgnoreComments | icomment | Ignore comments |
IgnoreCommentsOptions | icommopt | Ignore comments options |
IgnoreConstraintsNames | icnames | Ignore constraint names |
IgnoreDataTypesInColumn | idtc | Ignore data types in column |
IgnoreDefiner | idefiner | Ignore DEFINER caluse |
IgnoreDropIndexes | idropi | Ignore indexes present only in Target |
IgnoreEndsClause | iends | Ignore ENDS clause |
IgnoreForeignKeyActions | ifkacts | Ignore foreign keys actions ON UPDATE and ON DELETE |
IgnoreForeignKeys | ifk | Ignore foreign keys |
IgnoreFullTextIndexes | iftindex | Ignore fulltext indexes |
IgnoreIndexes | iindex | Ignore indexes |
IgnoreIndexesNames | iinames | Ignore indexes names |
IgnoreNotNullConstraints | inotnull | Ignore NOT NULL for a column |
IgnoreParserErrors | iparsererrors | Ignore parser errors |
IgnorePartitions | ipart | Ignore partitions |
IgnorePermissions | iperm | Ignore permissions |
IgnorePrimaryKeys | ipk | Ignore primary keys |
IgnoreRowFormat | irowformat | Ignore row format table option |
IgnoreSpatialIndexes | ispindex | Ignore spatial indexes |
IgnoreSqlSecurity | issec | Ignore SQL SECURITY clause |
IgnoreStartsClause | istarts | Ignore STARTS clause |
IgnoreSynonymForFunctions | ifuncsyn | Ignore synon for functions in source objects |
IgnoreTableDMLTriggers | itdmltrig | Ignore table DML triggers |
IgnoreTableEngine | iengine | Ignore table engine |
IgnoreTriggerFireOrder | ifire | Ignore firing order for DDL and DML triggers |
IncludeComparisonSettings | incsettings | Includes identical objects into your report |
IncludeSyncScript | incscript | Include synchronization script into sync report |
IncludeSyncWarnings | incwarn | Include synchronization warnings into sync report |
MappingIgnoreCase | micase | Ignore case in object names when mapping them |
MappingIgnoreSpaces | mispace | Ignore spaces in object names druing mapping and comparing |
MappingSimilar | msim | Associate column names having similar name options |