Troubleshooting differences in identical databases

You may encounter a situation where dbForge Studio shows differences when comparing two identical databases. This topic describes the reasons behind this and provides guidance on how to resolve the issue.

The Ignore trailing spaces option is not enabled

By default, dbForge Studio 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.

To ignore these differences when comparing text data, select the Ignore trailing spaces option.

The Ignore end of line option is not enabled

By default, dbForge Studio includes end of line characters, such as carriage return characters in comparison and synchronization. To ignore those characters, select the Ignore end of line option when configuring comparison options in the New Data Comparison wizard.

The Ignore leading spaces option is not enabled

By default, the Ignore leading spaces option is not enabled. To ignore white spaces at the beginning of strings, select this option when configuring comparison options for a new project.

Note

The Ignore leading spaces, Ignore trailing spaces, and Ignore end of line options can only be applied to (N)VARCHAR columns.