Ignore table DEFAULT constraints completely?

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

Ignore table DEFAULT constraints completely?

Postby weswinkler » Thu Jan 03, 2013 3:09 am

I know that SQL Compare provides options to ignore constraint and index names, and to ignore CHECK constraints.

But, is it possible to ignore all DEFAULT constraints on table columns?

I have some databases where the ONLY difference between several tables is the different value of a column DEFAULT. SQL Compare notes the differences and brings it to my attention.

Since I expect them and know about them, I'd like SQL Compare to ignore these differences. I'm willing to ignore ALL DEFAULT constraints to achieve this end.

Is it possible?

An excellent solution would be to ignore any DEFAULT constraints whose names fit a regular expression.

Posts: 32
Joined: Tue Nov 11, 2008 8:12 pm

Postby Brian Donahue » Tue Jan 15, 2013 11:34 am


We have got a feature request in to ignore column defaults: SC-4543. It may be implemented, depending on the feasability and amount of demand.
Brian Donahue
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests