Bug in SQL Data Compare 5.3.0.68?

Comments

• Chris Spencer Posts: 301

  November 1, 2007 11:45AM

  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

  Chris Spencer
  Test Engineer
  Red Gate

  0 · Share on Twitter
• darrenweiner Posts: 9

  November 1, 2007 12:17PM

  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.

  0 · Share on Twitter
• David Atkinson Redgate › Posts: 1,458 Rose Gold 2

  November 1, 2007 1:28PM

  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

  David Atkinson
  Product Manager
  Redgate Software

  0 · Share on Twitter