By default, dbForge Data Compare for MySQL generates a file with command-line arguments and records all comparison and synchronization options into it. Each option is displayed in the format:
/option_name:[Y/N]
You can edit the file to turn on/off the required options. To turn on comparison and synchronization options, set their values to “Yes”, “Y”, “True”, “T”, or “On”. To turn off the options, use “No”, “N”, “False”, “F”, or “Off”.
Each option has both a full name and a short name. Instead of editing the file, you can specify the desired option directly in the Command Prompt.
See below the list of options with their full and short command line names.
The table provides comparison and synchronization options with their full and short command-line names.
| Full name | Short name | Description |
|---|---|---|
| BulkMaxSize | bulkms | Specifies the maximum number of rows processed in a single bulk operation. |
| CheckConcurrencyUpdates | concupd | Prevents accidental data overwrites by adding non-key conditions to the WHERE clause of UPDATE and DELETE statements, and by using INSERT IGNORE statements. |
| CheckDifferent | chkdiff | Includes different records in comparison results. The records can then be selected for synchronization. |
| CheckIdentical | chkequal | Includes identical records in comparison results. |
| CheckOnlyInSource | chksource | Includes only source records in comparison results. The records can then be selected for synchronization. |
| CheckOnlyInTarget | chktarget | Includes only target records in comparison results. The records can then be selected for synchronization. |
| CompareTables | tables | Compares tables and includes them in comparison results. |
| CompareViews | views | Compares views and includes them in comparison results. To synchronize the views, ensure the IS_UPDATABLE option is selected. |
| ConvertFromArchiveEngine | convfromarc | Converts ARCHIVE tables to InnoDB to enable DML operations, then restores the original storage engine after synchronization. |
| DisableDmlTriggers | nodml | Disables DML triggers at the beginning of synchronization and re-enables them after synchronization completes. The option applies to tables. |
| DisableForeignKeys | nofk | Disables or drops foreign keys at the beginning of synchronization and enables or restores them after synchronization completes. |
| DropCheckConstraints | dropcheck | Drops the CHECK and NOT NULL constraints at the beginning of synchronization and restores them after synchronization completes. |
| DropKeys | dropkeys | Drops primary keys and indexes at the beginning of synchronization and restores them after synchronization completes. Note: Primary keys and indexes used as comparison keys aren’t dropped. |
| ExcludeComments | nocomments | Excludes comments from a synchronization script. |
| ExcludeNewAddedObjects | excnewaddedobj | Compares only tables and views explicitly included in the saved project (.dcomp). |
| ExcludeObjectsByMask | meobjmask | Excludes tables or views from comparison based on a custom wildcard or regular expression. |
| IgnoreCase | icase | Ignores the case of TEXT, TINYTEXT, MEDIUMTEXT, LONGTEXT and VARCHAR columns. The option doesn’t affect key comparison columns. |
| IgnoreColumnsByMask | micolmask | Excludes columns from comparison based on a custom wildcard or regular expression. |
| IgnoreComputedColumns | micomput | Excludes computed columns from comparison. |
| IgnoreEndOfLine | ieol | Ignores all carriage return and line feed characters during comparison. The option applies to CHAR, VARCHAR, TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT columns. It doesn’t affect key comparison columns.Note: Using the option with LONGTEXT may slow down comparison. |
| IgnoreInternalSpaces | iispaces | Ignores spaces, tabs, and other non-printable characters inside a string during comparison. The option applies to CHAR, VARCHAR, TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT columns. It doesn’t affect key comparison columns.Note: Using the option with LONGTEXT may slow down comparison. |
| IgnoreLeadingSpaces | ilspaces | Ignores leading spaces, tabs, and other non-printable characters in a string during comparison. The option applies to CHAR, VARCHAR, TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT. It doesn’t affect key comparison columns.Note: Using the option with LONGTEXT may slow down comparison. |
| IgnoreLobColumns | milob | Excludes LOB columns from comparison. The option applies to BLOB, LONGBLOB, MEDIUMBLOB, TINYBLOB, TEXT, LONGTEXT, MEDIUMTEXT, TINYTEXT, and JSON columns. |
| IgnoreMicroseconds | imsec | Ignores microseconds during comparison. The option applies to TIME(N), DATETIME(N), and TIMESTAMP(N). |
| IgnoreTemporalTableSysColumns | isyscol | Ignores SYSTEM_TIME and application-time period columns in temporal tables during comparison and synchronization. |
| IgnoreTrailingSpaces | itspaces | Ignores trailing spaces, tabs, and other non-printable characters in a string during comparison. The option applies to CHAR, VARCHAR, TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT columns. It doesn’t affect key comparison columns.Note: Using the option with LONGTEXT may slow down comparison. |
| IgnoreWhiteSpace | ispaces | Ignores whitespace characters during comparison of triggers, stored procedures, and functions. Original whitespaces in script object bodies are preserved during synchronization. |
| IncludeObjectsByMask | miobjmask | Compares only tables or views that match a specified wildcard or regular expression mask. |
| IncludeUseDatabase | inud | Adds a USE <database> statement to a synchronization script. |
| IsEmptyStringEqualsNull | emptyeqnull | Treats NULL and EMPTY STRING as the same value. |
| IsIgnoreTime | itime | Ignores the time component of DATETIME values during comparison. The option applies to DATETIME(N) and TIMESTAMP(N). |
| LimitBulk | limbulk | Limits the size of bulk operations by setting the maximum number of rows processed per batch. |
| MappingIgnoreCase | micase | Ignores lower and upper case differences in object names when mapping them. |
| MappingIgnoreSpaces | mispace | Ignores spaces in object names when mapping them. |
| MappingIgnoreUnderscores | miunder | Ignores underscores in object names when mapping them. |
| RoundFloatTypes | round | Rounds float types up to 3 digits. The option applies to DECIMAL, NUMERIC, FLOAT, REAL, DOUBLE, and DOUBLE PRECISION data types. It doesn’t affect key columns. |
| ToleranceInterval | tol | Specifies the maximum allowed difference (absolute value) between source and target values. If the difference doesn’t exceed this value, the values are considered equal. The option applies to INTEGER, SMALLINT, DECIMAL, NUMERIC, FLOAT, REAL, DOUBLE, and DOUBLE PRECISION. It doesn’t affect key columns. |
| Full name | Short name | Description |
|---|---|---|
| AppendTimestampReport | tsreport | Adds a timestamp to the folder name of a generated comparison report. |
| DifferentPerColumns | diffpercolumns | Displays the number of differences per column. |
| HideUnmodifiedColumns | hidecolumns | Excludes columns with no differences. |
| IncludeComparisonSettings | incsettings | Includes comparison and synchronization settings in a comparison report. |
| IncludeObjectsData | incdata | Includes object data in a comparison report. |
| IncludeSyncWarnings | incwarnings | Includes comparison or synchronization warnings in the report, if any. |
/datacompare /compfile:"D:\workDir\MySQLvsMySQL.dcomp"
/datacompare /source host:MySQLServer1 user:dbuser password:psw database:db1 /target host:MySQLServer2 user:dbuser password:pswd database:db2 /sync /log:"D:\sync.log"
/datacompare /source host:MySQLServer1 database:db1 user:dbuser password:pswd /target host:MySQLServer2 database:db2 user:dbuser password:pswd /sync:"D:\compare_result.sql"
/datacompare /compfile:"MySQL1vsMYSQL2.dcomp" /icase:yes /IgnoreComputedColumns:yes /report:"report.html" /reportformat:HTML /sync