problems with "add object existence checks"

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

problems with "add object existence checks"

Postby sasok » Thu Sep 20, 2012 1:42 pm

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..?
sasok
 
Posts: 1
Joined: Thu Sep 20, 2012 1:34 pm

Postby Chris Auckland » Mon Sep 24, 2012 5:02 pm

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
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 2 guests