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