Primar Key Constraint error

ChrisClementChrisClement Posts: 10
edited November 23, 2004 12:42PM in SQL Data Compare Previous Versions
I am trying to compare two tables that are exactly the same. I have run SQL Compare and verified their structures are identical. Now I am trying to copy the data from one to the other using SQL Data compare but I keep getting a "PRIMARY KEY constraint: Cannot insert duplicate key in object". Why would I be getting this when the source table has the same structure?? I can't have a duplicate primary key in the source obviously so how is it that I am getting this error??

Thanks for your help.

Chris Clement


This discussion has been closed.