Compare fails to find simple difference in field

rcroeder

Simple issue,

two databases, one on SQL2008R2 the other SQL2008. On field has the value of 'EquipMake' the other 'equipMake'. Compare says they are the same, If I change the value on either side it catches it. I have screen captures and a copy of the SC8 project file if needed. This took hours to find. I am not a happy camper since I just upgraded my dept to RedGate this week by buying a 5 seat license.

Field type Varchar[100]
Shows what iIsee inside of SQL data Compare
http://www.asmsdev.com/staging/uploads/8-20-2010%204-46-20%20PM.png

Shows what is inside of Databases
http://www.asmsdev.com/staging/uploads/8-20-2010%204-40-32%20PM.png

David Atkinson

SQL Data Compare honors the collation set on the column. It seems that your column must be case insensitive and SQL Data Compare interprets this as implying that you want to ignore such differences.

Could you consider changing the collation on the column?

Alternatively, you might want to try the 'Force binary collation' option (Edit Project / Options), which forces a case sensitive comparison.

Please get in touch and let us know how you get on or if you need help changing your column's collation.

Kind regards

David Atkinson
Red Gate Software