Scenarios, where Data Compare may show differences in two identical databases

Last modified: August 8, 2024

You may encounter a situation when Data Compare for SQL Server shows differences when comparing two identical databases. This may occur due to one of the following:

The Ignore trailing spaces option is not enabled

By default, Data Compare includes white spaces at the end of the strings in the comparison. For that reason, comparing a fixed-length field in one data source to a variable-length field in another may cause differences due to spaces. The Ignore trailing spaces option will allow you to ignore these differences when comparing text data.

Note

The Ignore trailing spaces option can be applied only to (N)VARCHAR columns.

The Ignore end of line option is not enabled

By default, the Data Compare tool includes end of line characters such as carriage return characters in comparison and synchronization. In case you want those characters to be ignored, don’t forget to enable the option when configuring the New Data Comparison Wizard.

Note

The Ignore end of line option can be applied only to (N)VARCHAR columns.

The Ignore leading spaces option is not enabled

By default, the option is disabled. Select it when configuring new project comparison options to make Data Compare ignore white spaces at the beginning of the strings.

Note

The Ignore leading spaces option can be applied only to (N)VARCHAR columns.