What are the challenges you face when working across database platforms? Take the survey

Compare fails to find simple difference in field

rcroederrcroeder Posts: 9
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

Shows what is inside of Databases
rc roeder


  • Options
    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
    David Atkinson
    Product Manager
    Redgate Software
Sign In or Register to comment.