Compares and synchronizes SQL database content.
I'm having problems sync'ing a table. When attempting to do a synch, data compare displays "Violation of primary key constraint. Cannot insert duplicate key into object tableblahblah.
In the project settings, I have disable foreign keys, drop primary keys, indexes, disable dml and ddl triggers checked. What else can I do to get the sync to properly occur?
- Posts: 8
- Joined: Wed Mar 23, 2011 8:22 pm
Thanks for your post.
It could be database triggers firing up causing this. If you have any triggers, could you try using the 'disable triggers' option?
- Posts: 760
- Joined: Tue Oct 24, 2006 2:12 pm
- Location: Red Gate Software Ltd.
Return to SQL Data Compare Previous Versions
Who is online
Users browsing this forum: No registered users and 0 guests