Options Used in Command Line for /datacompare

You can select the required options while setting the comparison in the Data Comparison wizard and generate a file with command line arguments by clicking Save settings to a command line arguments file on the Options wizard page. Also you can set comparison options by using the /option_name:[Y/N] switch in the Command Prompt. Specify either full or short names of the options. Here is the list of their names.

By default, dbForge Data Compare for MySQL generates a file with command line arguments and writes all 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 the Command Prompt instead of editing the file.

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

Options List

Full name Short name Description
BulkMaxSize bulkms Set the maximum data size for the bulk insert
CheckConcurrencyUpdates concupd Supplement UPDATE and DELETE commands with non-key values in the WHERE condition and add IF NOT EXISTS statement before the INSERT command
CheckDifferent chkdiff Include different records into the comparison result
CheckIdentical chkequal Include identical records into the comparison result
CheckOnlyInSource chksource Include into the comparison result only those records that exist in the Source
CheckOnlyInTarget chktarget Include into the comparison result only those records that exist in the Target
CompareTables tables Include tables into comparison
CompareViews views Include views into comparison
ConvertFromArchiveEngine convfromarc Convert Archive Engine to InnoDB for the UPDATE and DELETE operations possibility
DisableDmlTriggers nodml Disable triggers during synchronization
DisableForeignKeys nofk Drop foreign keys before synchronization
DropKeys dropkeys Drop primary keys and indexes before synchronization
ExcludeComments nocomments Exclude comments from the synchronization script
ExcludeNewAddedObjects excnewaddedobj Compare only those tables and views that are explicitly included into the project (.dcomp)
ExcludeObjectsByMask meobjmask Exclude tables or views from comparison by specifying a custom wildcard expression for their names
IgnoreBlobColumns miblob Ignore BLOB columns during comparison
IgnoreCase icase Ignore case in symbols for non-key columns
IgnoreColumnsByMask micolmask Exclude columns from comparison by specifying a custom wildcard expression for their names
IgnoreComputedColumns micomput Ignore computed columns during comparison
IgnoreEndOfLine ieol Ignore end of line character during comparison and synchronization
IgnoreLeadingSpaces ilspaces Ignore white spaces in the beginning of the strings during comparison and synchronization
IgnoreMicroseconds imsec Ignore microseconds in TIME, DATETIME, and TIMESTAMP datatypes
IgnoreParserErrors iparsererrors Ignore parser errors.
Note: The IgnoreParserErrors option is disabled by default.

When the option is disabled, errors in parsing a scripts folder lead to the interruption of data comparison.

When the option is enabled, errors in parsing a scripts folder are ignored and do not influence data comparison.
IgnoreTrailingSpaces itspaces Ignore white spaces in the end of the strings during comparison and synchronization
IgnoreWhiteSpace ispaces Ignore white spaces
IncludeComparisonSettings incsettings Include Comparison settings into the synchronization script
IncludeDifferencesPerColumns incdiffcols Include differences per columns
IncludeObjectsByMask miobjmask Include tables or views from comparison by specifying a custom wildcard expression for their names
IncludeObjectsData incdata Include objects data into the synchronization script
IncludeOnlyColumnsWithChanges inccolswchanges Include into synchronization only columns with changes
IncludeSyncScript incscript Include synchronization script
IncludeSyncWarnings incwarn Include synchronization warnings into the script
IncludeUseDatabase inud Add the USE DATABASE statement to the script
IsEmptyStringEqualsNull emptyeqnull Treat NULL and EMPTY STRING as the same value for CHAR and VARCHAR values when comparing Source and Target
IsIgnoreTime itime Ignore time for DATETIME fields during comparison, e.g. values ‘1995-09-29 03:14:15’ and ‘1995-09-29 22:14:06’ will be considered as equal
LimitBulk limbulk Set the data size for the bulk insert
MappingIgnoreCase micase Ignore case in objects names when mapping
MappingIgnoreSpaces mispace Ignore white spaces in objects names when mapping
MappingIgnoreUnderscores miunder ignore underscores in object names when mapping
RoundFloatTypes round Specify the number of digits after the decimal point
ToleranceInterval tol Specify the module of difference between the values of source and target, if the tolerance interval does not exceed the specified value, the values are considered equivalent
UseCommitMode commit Insert the COMMIT statement after each defined number of DML statements