SQL Compare Exclude constraints

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

SQL Compare Exclude constraints

Postby bbilow » Tue Dec 20, 2011 9:16 pm

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?

ie:(/Exclude:storedprocedure:proc_thisproc)
bbilow
 
Posts: 2
Joined: Tue Dec 20, 2011 9:05 pm

Postby Chris Auckland » Fri Dec 23, 2011 3:11 pm

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.
Chris
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests