Options

please help....hanging

masterbakermasterbaker Posts: 19
Hi,

I am trying to compare a folat type column, it came out there are 8023 rows differences, but when looking at the values, they are exactly the same.........so, I clicked on Sync, it takes forever to sync, actually, never ended.....please help....thanks for helping

Comments

  • Options
    Hi

    I am unsure what you mean by a folat type column - can you explain this in some more detail.
    Can you have another look at the values and see if they have case differences (if you are using a case sensitive collation) and if there are any trailing spaces that are making the differences.
    If you do have training spaces you can select the option to ignore them during the comparison.

    Regards
    Dan
    Daniel Handley
    Red Gate Software Ltd
Sign In or Register to comment.