Options Used in Command Line for /datacompare

Last modified: February 7, 2025

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
BulkInsert	bsize	Specifies if the multirow INSERT should be used to increase the data insert performance. When cleared, the single row INSERT is used.
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 <database_name> 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
BulkSize	bsize	Specifies the bulk size limit.
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