Red Gate forums :: View topic - Bug with IgnoreConstraintNames and WITH NOCHECK constraints
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

Bug with IgnoreConstraintNames and WITH NOCHECK constraints

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



Joined: 08 Jul 2011
Posts: 45

PostPosted: Wed Oct 16, 2013 10:33 pm    Post subject: Bug with IgnoreConstraintNames and WITH NOCHECK constraints Reply with quote

I am able to reliably reproduce an issue with the IgnoreConstraintNames option with SQL Compare 10.4.8.87.

If you specify IgnoreConstraintNames and two constraints have different WITH NOCHECK attributes set, then SQL Compare will try to create the constraint without dropping it first.

I was able to reproduce this issue on a database created from scratch with just two tables in it. Here are some images that illustrate the issue:
http://imgur.com/a/mfDmp


I also have a backup of both databases if you have any problems reproducing this.
Back to top
View user's profile Send private message
JackAce



Joined: 08 Jul 2011
Posts: 45

PostPosted: Wed Oct 16, 2013 11:08 pm    Post subject: Re: Bug with IgnoreConstraintNames and WITH NOCHECK constraints Reply with quote

FYI - As a work around, we have been specifying IgnoreWithNocheck, but this is not ideal.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6674

PostPosted: Mon Oct 21, 2013 4:26 pm    Post subject: Reply with quote

I believe this is an issue that was fixed in 10.5, but then 10.5 has been removed temporarily while a bug regarding migration scripts is being investigated. If you do not use migration scripts, can you please try using SQL Compare 10.5 and see if that solves the problem?

http://downloads.red-gate.com/checkforupdates/SQLCompare/SQLCompare_10.5.0.611.exe
Back to top
View user's profile Send private message
JackAce



Joined: 08 Jul 2011
Posts: 45

PostPosted: Tue Oct 22, 2013 5:11 pm    Post subject: Reply with quote

We'll probably wait until 10.5 is available with all migration issues resolved. Is there an ETA on when it will be released again?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6674

PostPosted: Wed Oct 23, 2013 10:22 am    Post subject: Reply with quote

Work starts in November, so probably mid-December, all going well.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6674

PostPosted: Thu Apr 24, 2014 3:38 pm    Post subject: Reply with quote

This issue should be fixed in version 10.7, which was released to Check for Updates yesterday.
Back to top
View user's profile Send private message
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