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.