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

sql data compare 8.1 generated sync script problem

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.
mdufrasne
0

Comments

1 comment

Sort by
  • mdufrasne
    I figured it out, the Database name is not specified in the script and the default database for my sql server was a different DB....
    mdufrasne
    0

Add comment

Please sign in to leave a comment.