We have an application that updates a target DB for us when we change revisions. I'm trying to use SQL COmpare to see if the update went OK.
The problem is that I have 3 identical tables and 646 that are different. But they are different in local generated constraint names or field order.
Is there a way to have SQL Compare, just compare the tables, columns and column definitions no matter the order?
If I go through the 646 tables, most are fine for our uses since we do not care if the fields are in any specific order.