Configure comparison options
You can use project options to configure the behavior of Data Compare.
- How to configure data comparison options
- Default options
- Full list of Data Compare comparison options
How to configure data comparison options
When you create a new project, you should run the comparison with the default options, then review your comparison results. After you have reviewed your comparison results, you may want to consider changing some of the options. The options you set are saved for each project, and you can modify them on the Options tab of the New Data Comparison wizard.
If you click Save Command Line, the Command Line Wizard will get opened.
For convenience, options can be grouped.
For each option, a detailed description is provided.
To search for an option, type search text in the Search box. The list is filtered to display only those options that contain the search text.
Default options
If you want to make the current selection of options your defaults, click Save as my defaults. These options will be used for all new projects.
To restore your defaults after making changes, click My Defaults.
If you need to reset all the options to their original settings, click Devart defaults.
Full list of Data Compare comparison options
| Default State | Option Group | Option Name | Option Description |
|---|---|---|---|
| Disabled | Auto Mapping | Ignore case in object names | Ignores case in object names during mapping and comparison. |
| Disabled | Auto Mapping | Ignore underscores in object names | Ignores underscores in object names when mapping them. |
| Enabled | Auto Mapping | Ignore spaces in object names | Ignores spaces in object names when mapping them. |
| Disabled | Auto Mapping | Include tables or views by mask | Allows specifying a custom wildcard expression for tables or views names to include them in comparison. |
| Disabled | Auto Mapping | Exclude tables or views by mask | Allows specifying a custom wildcard expression for tables or views names to exclude them from comparison. |
| Disabled | Auto Mapping | Ignore BLOB columns | Ignores BLOB columns during the comparison. The option can be applied to the following column types: IMAGE, (N)TEXT, (N)VARCHAR(max), VARBINARY(max), XML. |
| Disabled | Auto Mapping | Ignore columns by mask | Allows specifying a custom wildcard expression for column names to exclude columns from comparison. |
| Enabled | Auto Mapping | Ignore computed columns | Ignores computed columns in tables during comparison. |
| Disabled | Auto Mapping | Exclude newly added objects | Allows comparing only those tables and views that were explicitly added to comparison project (*.dcomp). |
| Disabled | Auto Mapping | Ignore TIMESTAMP columns | Ignores the TIMESTAMP columns during comparison. The TIMESTAMP columns cannot be synchronized. |
| Disabled | Auto Mapping | Ignore ROWGUILD columns | Ignores the ROWGUILD columns during comparison. |
| Disabled | Auto Mapping | Ignore IDENTITY columns | Ignores the IDENTITY columns during comparison. You cannot synchronize a view if it contains an IDENTITY column. |
| Enabled | Comparison options | Compare tables | Includes tables in comparison. |
| Disabled | Comparison options | Compare views | Includes views in comparison. Views can be synchronized only if the referenced rows are from a single table, and do not include IDENTITY or computed columns. |
| Disabled | Comparison options | Compare memory-optimized tables | Includes memory-optimized tables in comparison. |
| Disabled | Comparison options | Compare tables with COLUMNSTORE indexes | Includes tables with COLUMNSTORE indexes in comparison. |
| Disabled | Comparison options | Compare history table for temporal tables | Includes a history table for temporal tables in comparison. |
| Disabled | Comparison options | Ignore SYSTEM_TIME columns for temporal tables | Includes SYSTEM_TIME columns for temporal tables in comparison. SYSTEM_TIME columns cannot be synchronized. |
| Disabled | Comparison options | Round float types up to |
Allows specifying the number of digits after the decimal point. The option rounds FLOAT, NUMERIC, REAL, DECIMAL, MONEY, and SMALLMONEY datatypes. |
| Disabled | Comparison options | Compare CLR types as binary | Allows comparing and synchronizing CLR types as binary. When the option is disabled, CLR types are compared as a string. |
| Disabled | Comparison options | Ignore leading spaces | Ignores white-space characters at the beginning of each string during comparison and synchronization. |
| Disabled | Comparison options | Ignore trailing spaces | Ignores white-space characters at the end of each string during comparison and synchronization. |
| Disabled | Comparison options | Ignore case | Ignores character case for non-key columns of the following data types: (N)CHAR, (N)VARCHAR, (N)VARCHAR(MAX), (N)TEXT, CLR. |
| Disabled | Comparison options | Ignore end of line | Ignores end of line characters during comparison and synchronization. |
| Disabled | Comparison options | Treat NULL and EMPTY STRING as the same value | Treats NULL and EMPTY STRING as equal for CHAR and VARCHAR values during the comparison. |
| Disabled | Comparison options | Ignore time part in DATETIME data types | Ignores data that represents time in the DATETIME data types fields and compares only dates. |
| Disabled | Comparison options | Tolerance interval | Allows specifying the module of difference between the source and target values. If it doesn’t exceed the specified limit, the values are considered to be equal. The option affects numeric datatype comparison excluding comparison key columns. |
| Enabled | Display options | Different records | Includes different records into the comparison results. These records are displayed in the results grid and can be included in synchronization. |
| Enabled | Display options | Only in source records | Includes only in source records into the comparison results. These records are displayed in the results grid and can be included in synchronization. |
| Enabled | Display options | Only in target records | Includes only in target records into the comparison results. These records are displayed in the results grid and can be included in synchronization. |
| Enabled | Display options | Identical records | Includes identical records into the comparison results. These records are displayed in the results grid. |