I'm experimenting with the SQL Schema Compare in Visual Studio 2012 Premium.
How do I ignore the column order in the comparison?
I found some posts that state this option was introduced in VS 2010, but I only see "Ignore column collation" the option in VS2012. (Discussion for vs2010)
How do I ignore any differences in the names of the constraints in the comparison?
The constraints should be present, but do not need to have the same name.
The ignore column order was removed for VS2012 according to this link
As for ignoring the constraint name the only way I could see it done is visually comparing it. I am assuming you are wanting to do this because you have system-generated constraint names. You can avoid system-generated constrain name to overcome the issue.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With