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 can configure the comparison options to meet your project’s needs most precisely. The options are set on the Options tab of the New Data Comparison wizard.
Note
If after setting data sources, you click Compare on the Source and Target page of the wizard, the comparison will be performed with the default options.
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.
Save the settings
To save the settings to a command-line file, in the Save drop-down menu, select Save Command Line and then in the dialog that opens click Save.
To save the settings as a data comparison project, in the Save drop-down menu, select Save Document, provide a path to store the file, and click Save.
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 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 LOB columns | Ignores LOB columns during the comparison. The option can be applied to the following column types: TEXT, BYTEA, XML, CHARACTER VARYING, CHARACTE, BIT, and BIT VARYING with the length over 8000. |
| Disabled | Auto Mapping | Ignore columns by mask | Allows specifying a custom wildcard expression for column names to exclude columns from comparison. |
| Disabled | Auto Mapping | Ignore serial columns | Ignores serial columns in tables during comparison. The option can be applied to the SERIAL and BIGSERIAL columns. |
| 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). |
| 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 | Round float types up to 3 digits | Allows rounding a decimal number by specifying the number of digits after the decimal point. |
| Disabled | Comparison options | Ignore case | Ignores character case when comparing non-key columns of the following data types: CHAR, CHARACTER VARYING, and TEXT. |
| Disabled | Comparison options | Ignore leading spaces | Ignores spaces, tabs, and other non-printable characters at the beginning of a string during the comparison. The option can be applied to the CHAR, VARCHAR, CHARACTER, CHARACTER VARYING, and TEXT columns. |
| Disabled | Comparison options | Ignore trailing spaces | Ignores spaces, tabs, and other non-printable characters at the end of a string during the comparison. This option can be applied to the CHAR, VARCHAR, CHARACTER, CHARACTER VARYING, and TEXT columns. |
| Disabled | Comparison options | Ignore internal spaces | Ignores spaces, tabs, and other non-printable characters in the middle of a string during the comparison. The option can be applied to the CHAR, VARCHAR, CHARACTER, CHARACTER VARYING, and TEXT columns. |
| Disabled | Comparison options | Ignore end of line | Ignores all carriage return and line feed characters during comparison. The option can be applied to the CHAR, VARCHAR, CHARACTER, CHARACTER VARYING, and TEXT columns. |
| Disabled | Comparison options | Treat NULL and EMPTY STRING as the same value | Treats NULL and EMPTY STRING as the same value for the CHARACTER VARYING, NAME, and TEXT 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 | Specifies the tolerance range for comparing the source and target values. |
| 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. |