There are quite a few reasons why Data Compare could try to violate a primary key: for example, the product enforces uniqueness of your comparison key which defaults to the primary key, but you can set it to something else if you know how your rows should be distinguished from each other.
Some detailed information would be useful to help understand why Data Compare is not behaving as you expected.
Comments
Thanks for your post.
Can you please let me know the exact error you are getting?
And also the version of SQL Data Compare you are using? (Help --> About SQL Data Compare)
Product Support
Redgate Software Ltd.
E-mail: [email protected]
I'm getting the same error while synchronising DB from one server to another using SQL Data Compare 11.
Can anyone help me out with this?
Thanks,
Hiren
Some detailed information would be useful to help understand why Data Compare is not behaving as you expected.
Redgate Software