Table compare/version 10

Forum for users of SQL Compare schema synchronization utility

Table compare/version 10

Postby mroynan » Thu Jan 05, 2012 3:04 pm

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?
Posts: 1
Joined: Thu Jan 05, 2012 3:00 pm

Postby andy.campbell.smith » Mon Jan 09, 2012 10:42 am

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:

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: ... _in_the_cl

Hope that helps!
Andy Campbell Smith

Red Gate Technical Support Engineer
Posts: 173
Joined: Thu Oct 20, 2011 10:19 am
Location: Red Gate Software

Postby alice.easey » Mon Jan 09, 2012 2:02 pm

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.
Posts: 94
Joined: Wed Feb 27, 2008 11:56 am
Location: Red Gate

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests