Compares and synchronizes SQL Server databases, backups and scripts.
Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong
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.
- Posts: 1
- Joined: Wed Mar 20, 2013 9:13 pm
- Location: Ontario, Canada
Return to SQL Compare 10
Who is online
Users browsing this forum: No registered users and 1 guest