Cannot sync table - violation of primary key constraint

Compares and synchronizes SQL database content.

Cannot sync table - violation of primary key constraint

Postby JonBoy » Wed Aug 24, 2011 11:57 am

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 7:22 pm

Postby Chris Auckland » Fri Aug 26, 2011 3:14 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?
Chris Auckland
Posts: 760
Joined: Tue Oct 24, 2006 1: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