sql data compare 8.1 generated sync script problem
mdufrasne
Posts: 3
SQL Data compare 8.1 can sync a series of tables from two different DBs great, but when I try to run the script it generates, I get a
Violation of PRIMARY KEY constraint 'PK_XXX'. Cannot insert duplicate key in object 'security.XXX'.
Even though there is no data anywhere in that table.
Has anyone encountered this? Where the SQL Data Compare itself can sync tables, but the script it generates is busted.
Violation of PRIMARY KEY constraint 'PK_XXX'. Cannot insert duplicate key in object 'security.XXX'.
Even though there is no data anywhere in that table.
Has anyone encountered this? Where the SQL Data Compare itself can sync tables, but the script it generates is busted.
Comments