What are the challenges you face when working across database platforms? Take the survey

How can I ignore a column default constraint?

hinsonahinsona Posts: 14 Bronze 1
edited July 31, 2019 3:04PM in SQL Compare
I am using SQL Compare Std.

I have a specific default constraint that is different in every copy of our databases - of which I currently have 50+ and growing.  

I see there's a way to ignore constraint and index names, and system generated constraint and index names. However, it would be nice if there was a way to ignore constraints by the name of the column they affect or a partial constraint name.

Is this possible? 

Edit: Maybe this can be done using filtering? There is a "default" filter object type, but after some experimentation it doesn't seem to do what I want. It's possible that I'm not using it correctly - yesterday was the first time I've used it.


Best Answer


Sign In or Register to comment.