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

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

RWilcoxRWilcox Posts: 1 New member
 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?
Tagged:

Answers

Sign In or Register to comment.