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 |
|---|---|---|
| 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 |
| 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 |
Want to Find out More?
Overview
All features
Request a demo
