Table compare/version 10

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

Table compare/version 10

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

Postby andy.campbell.smith » Mon Jan 09, 2012 11: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:

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/C ... _in_the_cl

Hope that helps!
Andy Campbell Smith

Red Gate Technical Support Engineer
andy.campbell.smith
 
Posts: 173
Joined: Thu Oct 20, 2011 11:19 am
Location: Red Gate Software

Postby alice.easey » Mon Jan 09, 2012 3: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.
alice.easey
 
Posts: 94
Joined: Wed Feb 27, 2008 12:56 pm
Location: Red Gate


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests