Red Gate forums :: View topic - Cannot sync table - violation of primary key constraint
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare Previous Versions
SQL Data Compare Previous Versions forum

Cannot sync table - violation of primary key constraint

Search in SQL Data Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
JonBoy



Joined: 23 Mar 2011
Posts: 8

PostPosted: Wed Aug 24, 2011 12:57 pm    Post subject: Cannot sync table - violation of primary key constraint Reply with quote

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?
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 755
Location: Red Gate Software Ltd.

PostPosted: Fri Aug 26, 2011 4:14 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group