Red Gate forums :: View topic - problems with "add object existence checks"
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

problems with "add object existence checks"

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
sasok



Joined: 20 Sep 2012
Posts: 1

PostPosted: Thu Sep 20, 2012 1:42 pm    Post subject: problems with "add object existence checks" Reply with quote

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..?
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 755
Location: Red Gate Software Ltd.

PostPosted: Mon Sep 24, 2012 5:02 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group