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 Studio 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 Option
BulkMaxSize bulkms Maximum size of bulk
CheckConcurrencyUpdates concupd Check for concurrency updates
CheckDifferent chkdiff Include different records into comparison results
CheckIdentical chkequal Include identical records into comparison results
CheckOnlyInSource chksource Include only in source records into comparison results
CheckOnlyInTarget chktarget Include only in target records into comparison results
CompareTables tables Include tables into comparison
CompareViews views Include views into comparison
ConvertFromArchiveEngine convfromarc Convert from archive engines
DisableDmlTrigger nodml Disable DML triggers
DisableForeignKeys nofk Disable foreign keys
DropKeys dropkeys Disable primary keys, indexes and unique constraints
ExcludeComments nocomments Exclude comments
ExcludeObjectsByMask meobjmask Exclude tables or views from comparison by specifying a custom wildcard expression
IgnoreBlobColumns miblob Ignore BLOB columns during comparison
IgnoreCase icase Ignore case in object names when mapping them
IgnoreColumnsByMask micolmask Exclude columns from comparison by specifying a custom wildcard expression for columns names
IgnoreComputedColumns micomput Ignore computed columns in tables during comparison
IgnoreEndOfLine ieol Ignore end of line characters during comparison and synchronization
IgnoreLeadingSpaces ilspaces Ignore leading spaces
IgnoreMicroseconds imsec Ignore microseconds for the following data types: TIME(n), DATETIME(n) and TIMESTAMP(n)
IgnoreTrailingSpaces ispaces Ignore whitespaces in the end of strings during comparison and synchronization
IncludeComparisonSettings incsettings Include comparison settings
IncludeDifferencesPerColumns incdiffcols Include differences per columns
IncludeIdenticalObjects incident Include identical objects
IncludeObjectsByMask miobjmask Include tables or views from comparison by specifying a custom wildcard expression
IncludeObjectsData incdata Include object data
IncludeOnlyColumnsWithChanges inccolswchanges Include only columns with changes
IncludeUseDatabase inud Include USE clause to the script
IsEmptyStringEqualsNull emptyeqnull Treat NULL and EMPTY STRING as the same value for CHAR and VARCHAR values while comparing
IsIgnoreTime itime Ignore time for DATETIME fields and compare only DATE part
LimitBulk limbulk Limit size of bulk
MappingIgnoreCase micase Ignore case in object names when mapping them
MappingIgnoreSpaces mispace Ignore spaced in object names when mapping them
MappingIgnoreUnderscores miunder Ignore underscores in object names when mapping them
RoundFloatTypes round Specify the count of digits after the decimal point. Option rounds float numeric, real and decimal data types
ToleranceInterval tol Tolerance interval
UseCommitMode commit Insert the commit statement after each commit page length statements