Configure comparison options

You can use project options to configure the behavior of Data Compare.

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.

New Data Comparison

If you click Save Command Line, the Command Line Wizard will get opened.

For convenience, options can be grouped.

Grouped comparison options

For each option, a detailed description is provided.

Option description

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.

Search in options

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.

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 digits 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.