Red Gate forums :: View topic - Table compare/version 10
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

Table compare/version 10

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



Joined: 05 Jan 2012
Posts: 1

PostPosted: Thu Jan 05, 2012 4:04 pm    Post subject: Table compare/version 10 Reply with quote

In version 10 standard edition, is there a way to only compare table schema (not views, stored procedures, etc.) in either the command line or GUI interface?
Back to top
View user's profile Send private message
andy.campbell.smith



Joined: 20 Oct 2011
Posts: 159
Location: Red Gate Software

PostPosted: Mon Jan 09, 2012 11:42 am    Post subject: Reply with quote

You can set up a custom filter in the SQL Compare GUI to limit the comparison to schema objects - I've included an example as a screenshot here:

http://i.imgur.com/zxqYi.png

Is that what you're after? You can do the same thing in the command line by setting up and saving the filter in the GUI, and then using the /Filter switch. There's a little more information about command line switches for SQL Compare here:

http://www.red-gate.com/supportcenter/Content/SQL_Compare/help/10.0/sc_cl_Switches_in_the_cl

Hope that helps!
_________________
Andy Campbell Smith

Red Gate Technical Support Engineer
Back to top
View user's profile Send private message
alice.easey



Joined: 27 Feb 2008
Posts: 93
Location: Red Gate

PostPosted: Mon Jan 09, 2012 3:02 pm    Post subject: Reply with quote

Just to add to what Andy said: The commandline is a SQL Compare Pro feature so you'd need to upgrade to be able to use this. The filters come with Standard edition though so this should work with your current licence.
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