Red Gate forums :: View topic - SQL Compare Exclude constraints
Return to RSS Feed Available

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

SQL Compare Exclude constraints

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

Joined: 20 Dec 2011
Posts: 2

PostPosted: Tue Dec 20, 2011 9:16 pm    Post subject: SQL Compare Exclude constraints Reply with quote

I'm in the process of creating a continuous integration system and I have a few issues with constraints causing issues when SQLDataCompare is run to sync data from SVN. Is there a switch or something that I can use to exclude constraints the same way that other objects can be excluded?

Back to top
View user's profile Send private message
Chris Auckland

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

PostPosted: Fri Dec 23, 2011 3:11 pm    Post subject: Reply with quote

Thanks for your post.

There is a project option to ignore constraints and indexes, but they don't get ignored when the database is deployed.

There is an option with SQL Data Compare that forces the constraints to be enabled with NOCHECK. This would mean you could also deploy the constraints, but the existing data won't be validated against the constraint when it gets created. This might be helpful, unless you actually want the constraints to be different.
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