SQL Data Compare 14

Case-sensitive comparisons

By default, columns inherit the collation of the database. If you are working with case-insensitive databases, you can run a case-sensitive comparison by selecting the project configuration option Force binary collation (case-sensitive). The setting applies to all columns that contain string data. To perform a case-sensitive comparison, SQL Data Compare uses the Latin1_General_BIN collation.

For example, if you compare Widget and widget, when the project option is not selected, SQL Data Compare considers the data to be identical. When the option is selected, SQL Data Compare identifies the case difference.

If you want to compare objects whose names differ only by their case, such as table names or column names, ensure the Ignore case of object names option is selected.


Didn't find what you were looking for?