SQL compare 8.2 - Newbie question about filtering

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

SQL compare 8.2 - Newbie question about filtering

Postby NickHUK » Wed Feb 08, 2012 11:34 am

Hi there.

I am new to SQL compare and need to compare two databases.

I have no interest in the data in the tables just the field definitions in the table.

I have quite a few tables that have the same fields (with the same name) but they are in a different order in the tables.

I don't want the compare to flag the order differences I just want it to match the fields by name and flag if they are not defined the same.

Am I able to do this using the filters?

Kind regards,
Nick
NickHUK
 
Posts: 1
Joined: Wed Feb 08, 2012 11:23 am

Postby Michelle Taylor » Thu Feb 09, 2012 6:58 pm

There's a project option for this - if you look at the Options tab of the Edit Project dialog, there's an option named 'Force Column Order'. If you uncheck the box next to that option, your comparison should ignore column order in tables.
Michelle Taylor
 
Posts: 529
Joined: Mon Oct 30, 2006 12:45 pm
Location: Red Gate Software


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests

cron