Red Gate forums :: View topic - Ignore table DEFAULT constraints completely?
Return to www.red-gate.com RSS Feed Available

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

Ignore table DEFAULT constraints completely?

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



Joined: 11 Nov 2008
Posts: 32

PostPosted: Thu Jan 03, 2013 3:09 am    Post subject: Ignore table DEFAULT constraints completely? Reply with quote

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.

Thanks!!
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6677

PostPosted: Tue Jan 15, 2013 11:34 am    Post subject: Reply with quote

Hello,

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.
Back to top
View user's profile Send private message
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