sql data compare 8.1 generated sync script problem

mdufrasne

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

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