Red Gate forums :: View topic - SQL compare 8.2 - Newbie question about filtering
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

SQL compare 8.2 - Newbie question about filtering

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
NickHUK



Joined: 08 Feb 2012
Posts: 1

PostPosted: Wed Feb 08, 2012 11:34 am    Post subject: SQL compare 8.2 - Newbie question about filtering Reply with quote

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
Back to top
View user's profile Send private message
Michelle Taylor



Joined: 30 Oct 2006
Posts: 529
Location: Red Gate Software

PostPosted: Thu Feb 09, 2012 6:58 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group