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

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.

Ignore options

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.

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Data Compare for SQL Server.
All Features

All features

Get acquainted with the rich features and capabilities of the Data Compare in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Data Compare for your business, request a demo to see it in action.
Ready to start using dbForge Data Compare for SQL Server?