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 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

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for MySQL.
All Features

All features

Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for MySQL?