Incorrect constraint syncing in SqlCompare 8.50.12.20

Forum for users of SQL Compare schema synchronization utility

Moderators: JonathanWatts, Chris Auckland, David Atkinson

Incorrect constraint syncing in SqlCompare 8.50.12.20

Postby CarissaMiller » Tue Apr 24, 2012 3:21 pm

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
CarissaMiller
 
Posts: 2
Joined: Mon May 23, 2011 11:01 pm

Postby peter.peart » Wed Apr 25, 2012 4:19 pm

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
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids


Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests

cron