Bug in SQL Data Compare 5.3.0.68?

darrenweiner

data compare is very clearly not comparing case differences when the Ignore case is unchecked. Is this a known bug?

Chris Spencer

The Ignore case option only affects object mappings. Therefore if Ignore case is checked table db1.Customer is automatically mapped to db2.customer. If left unchecked on a case-sensitive server the tables will not be matched.

It doesn't affect how data is compared.

If you have case-insensitive databases and you wish to perform a case-sensitive comparison then the Force Binary Collation option would be better suited. This has been enhanced in Data Compare v6.0 to perform a case-sensitive comparison of data (in v5.3 it only deals with the comparison keys).

Hope this helps

Regards
Chris

darrenweiner

Thanks for the info. Makes sense that the default case setting on the box is still adhered to, just thought that box overrode it....I'll try the binary option going forward.

David Atkinson

In SQL Data Compare 5, we don't override the server collation. SQL Data Compare 6 is able to do this.

A workaround exists for SQL Compare 5 whereby you effectively alter the collation of your table prior to the comparison, and change it back afterwards (or leave it as it is). This is detailed at:

http://www.red-gate.com/MessageBoard/viewtopic.php?t=3775

David Atkinson
Red Gate Software