| Author |
Message |
weswinkler
Joined: 11 Nov 2008 Posts: 32
|
Posted: Thu Jan 03, 2013 3:09 am Post subject: Ignore table DEFAULT constraints completely? |
|
|
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 |
|
 |
Brian Donahue
Joined: 23 Aug 2004 Posts: 6341 Location: Red Gate Software
|
Posted: Tue Jan 15, 2013 11:34 am Post subject: |
|
|
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. _________________ Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
 |
|
|
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