Red Gate forums :: View topic - Incorrect constraint syncing in SqlCompare 8.50.12.20
Return to www.red-gate.com RSS Feed Available

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

Incorrect constraint syncing in SqlCompare 8.50.12.20

Search in SQL Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
CarissaMiller



Joined: 23 May 2011
Posts: 2

PostPosted: Tue Apr 24, 2012 3:21 pm    Post subject: Incorrect constraint syncing in SqlCompare 8.50.12.20 Reply with quote

I ran Sql Compare 8.50.12.20 to compare two Sql Server databases, and there was a check constraint on the source table in the form ((a and b and c) or (d and e and f)). However, Sql Compare read it as ((a and b and c or d and e and f)) and inserted this version in the synchronization script, which changes the logical meaning of the constraint. Has this been fixed in future versions of Sql Compare?

Thanks,
Carissa
Back to top
View user's profile Send private message
peter.peart
Site Admin


Joined: 02 Sep 2008
Posts: 362
Location: Top floor, RG towers with the cool kids

PostPosted: Wed Apr 25, 2012 4:19 pm    Post subject: Reply with quote

Thanks for your post. I believe there has been some work done here, but the best thing really is for you to try out V10 in your environment.

Is this something you're able to do? If it isn't fixed, we can then raise an issue for V10.

Pete
_________________
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
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