What are the challenges you face when working across database platforms? Take the survey
Options

problems with "add object existence checks"

sasoksasok Posts: 2
edited September 24, 2012 12:02PM in SQL Compare Previous Versions
Hi,

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:

Rebuilding [uni].[StudentGroup]
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..?

Comments

  • Options
    Sorry you're hitting this issue.

    This is actually a known problem with our existence check if the default constraint is not on the default schema. Our internal reference for this bug is SC-5670. It has already been fixed by our development team and should be available in the next SQL Compare update. (Any build > 10.2.0
    1565).

    The only workarounds would be to either turn off the existence checks, or modify the script to fully qualify the constraint in the existence check.
    Chris
Sign In or Register to comment.