Comments
11 comments
-
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 -
Tianjiao_Li said:
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. 😒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
https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/3463480-ignore-default-x-column-constraints
-
Thanks. There's already a post on uservoice and it's 7 years old. So I'm guessing it'll probably never happen.
-
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.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
https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/3463480-ignore-default-x-column-constraints
-
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.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
https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/3463480-ignore-default-x-column-constraints
-
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.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
https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/3463480-ignore-default-x-column-constraints
-
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.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
https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/3463480-ignore-default-x-column-constraints
-
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.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
https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/3463480-ignore-default-x-column-constraints
-
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.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
https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/3463480-ignore-default-x-column-constraints
-
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.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
https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/3463480-ignore-default-x-column-constraints
-
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.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
https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/3463480-ignore-default-x-column-constraints
Add comment
Please sign in to leave a comment.
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.