SQL Compare - Why does the option 'Ignore Constraints' NOT ignore default constraint values?

RWilcox

 Many of my databases have 1 column in every table with the same default value to identity which client owns that row when all the databases are replicated into 1 main database.  Each time I try to compare 2 client databases, knowing the only difference should be the default constraint value in that one column, it will always show every table being different.  
 How can I tell SQL Compare to really IGNORE Default Constraint values?

Jon_Kirkwood

Hi @RWilcox

 Thank you for reaching out on the Redgate forums.

I can confirm that at this time there is no option for ignoring default constraints. I do apologize for the inconvenience that this brings.

 

Looking at our Uservoice forum I believe you may have already raised a request for this - I may suggest voting on this one if it matches your request as it has more votes and more potential to be implemented into SQL Compare:

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