How can I ignore a column default constraint?

hinsona

I am using SQL Compare 13.7.16.11325 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.

Thanks.

Tianjiao_Li

Unfortunately what you are asking is not possible and it can't be achieved using filter either as filters only apply at the object/table level.

Can you please leave it on our user voice forum? https://redgate.uservoice.com/forums/141379-sql-compare

hinsona

Tianjiao_Li said:

Unfortunately what you are asking is not possible and it can't be achieved using filter either as filters only apply at the object/table level.

Can you please leave it on our user voice forum? https://redgate.uservoice.com/forums/141379-sql-compare

Thanks for letting me know, though I doubt anything will come of it.  There's a uservoice post requesting this very feature in the top 20 of requests and is dated from 2012. 😒

https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/3463480-ignore-default-x-column-constraints

hinsona

Thanks. There's already a post on uservoice and it's 7 years old. So I'm guessing it'll probably never happen.

hinsona

Tianjiao_Li said:

Unfortunately what you are asking is not possible and it can't be achieved using filter either as filters only apply at the object/table level.

Can you please leave it on our user voice forum? https://redgate.uservoice.com/forums/141379-sql-compare

Thanks for letting me know. There's already a request for this very feature in the top 20, though it's 7 years old. I'm guessing me voting on it is going to make zero difference in that feature's priority. Oh well.

https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/3463480-ignore-default-x-column-constraints

hinsona

Tianjiao_Li said:

Unfortunately what you are asking is not possible and it can't be achieved using filter either as filters only apply at the object/table level.

Can you please leave it on our user voice forum? https://redgate.uservoice.com/forums/141379-sql-compare

Thanks for letting me know. There's already a request for this very feature in the top 20, though it's 7 years old. I'm guessing me voting on it is going to make zero difference in that feature's priority. Oh well.

https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/3463480-ignore-default-x-column-constraints

hinsona

Tianjiao_Li said:

Unfortunately what you are asking is not possible and it can't be achieved using filter either as filters only apply at the object/table level.

Can you please leave it on our user voice forum? https://redgate.uservoice.com/forums/141379-sql-compare

Thanks for letting me know. There's already a request for this very feature in the top 20, though it's 7 years old. I'm guessing me voting on it is going to make zero difference in that feature's priority. Oh well.

https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/3463480-ignore-default-x-column-constraints

hinsona

Tianjiao_Li said:

Unfortunately what you are asking is not possible and it can't be achieved using filter either as filters only apply at the object/table level.

Can you please leave it on our user voice forum? https://redgate.uservoice.com/forums/141379-sql-compare

Thanks for letting me know. There's already a request for this very feature in the top 20, though it's 7 years old. I'm guessing me voting on it is going to make zero difference in that feature's priority. Oh well.

https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/3463480-ignore-default-x-column-constraints

hinsona

Tianjiao_Li said:

Unfortunately what you are asking is not possible and it can't be achieved using filter either as filters only apply at the object/table level.

Can you please leave it on our user voice forum? https://redgate.uservoice.com/forums/141379-sql-compare

Thanks for letting me know. There's already a request for this very feature in the top 20, though it's 7 years old. I'm guessing me voting on it is going to make zero difference in that feature's priority. Oh well.

https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/3463480-ignore-default-x-column-constraints

hinsona

Tianjiao_Li said:

Unfortunately what you are asking is not possible and it can't be achieved using filter either as filters only apply at the object/table level.

Can you please leave it on our user voice forum? https://redgate.uservoice.com/forums/141379-sql-compare

Thanks for letting me know. There's already a request for this very feature in the top 20, though it's 7 years old. I'm guessing me voting on it is going to make zero difference in that feature's priority. Oh well.

https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/3463480-ignore-default-x-column-constraints

hinsona

Tianjiao_Li said:

Unfortunately what you are asking is not possible and it can't be achieved using filter either as filters only apply at the object/table level.

Can you please leave it on our user voice forum? https://redgate.uservoice.com/forums/141379-sql-compare

Thanks for letting me know. There's already a request for this very feature in the top 20, though it's 7 years old. I'm guessing me voting on it is going to make zero difference in that feature's priority. Oh well.

https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/3463480-ignore-default-x-column-constraints

hinsona

Tianjiao_Li said:

Unfortunately what you are asking is not possible and it can't be achieved using filter either as filters only apply at the object/table level.

Can you please leave it on our user voice forum? https://redgate.uservoice.com/forums/141379-sql-compare

Thanks for letting me know. There's already a request for this very feature in the top 20, though it's 7 years old. I'm guessing me voting on it is going to make zero difference in that feature's priority. Oh well.

https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/3463480-ignore-default-x-column-constraints