| Author |
Message |
JonBoy
Joined: 23 Mar 2011 Posts: 8
|
Posted: Wed Aug 24, 2011 12:57 pm Post subject: Cannot sync table - violation of primary key constraint |
|
|
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 |
|
 |
Chris Auckland
Joined: 24 Oct 2006 Posts: 710 Location: Red Gate Software Ltd.
|
Posted: Fri Aug 26, 2011 4:14 pm Post subject: |
|
|
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 |
|
 |
|
|
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