How can we help you today? How can we help you today?

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?
JonBoy
0

Comments

1 comment

  • Chris Auckland
    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
    0

Add comment

Please sign in to leave a comment.