Bug in SQL Data Compare 5.3.0.68?

• 
  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 November 01, 2007 11:45

  - 0 +
• 
  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.

  darrenweiner November 01, 2007 12:17

  - 0 +
• 
  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 November 01, 2007 13:28

  - 0 +

Add comment

Please sign in to leave a comment.