Cannot sync table - violation of primary key constraint
JonBoy
Posts: 10
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?
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?
Comments
It could be database triggers firing up causing this. If you have any triggers, could you try using the 'disable triggers' option?