Simple compare of tables and columns

Bob LawsonBob Lawson Posts: 2
edited March 22, 2013 5:19PM in SQL Compare Previous Versions
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.



Sign In or Register to comment.