I'm evaluating SQL Compare 10 and I'm having a problem.
I'm trying to synchronize a simple database. If I select "Add object existence checks" then the generated script is not working. This is the error I get:
Msg 2714, Level 16, State 5, Line 1
There is already an object named 'DF_StudentGroup_StudentByLastName' in the database.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
I've just also tried generating a script with the "Add object existence checks" disabled and that seems to be working; but I would prefer to have the existence checks...
Is there something I'm doing wrong..?