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
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 4:00 pm
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:
http://www.red-gate.com/supportcenter/C ... _in_the_cl
Hope that helps!
Andy Campbell Smith
Red Gate Technical Support Engineer
- Posts: 173
- Joined: Thu Oct 20, 2011 11:19 am
- Location: Red Gate Software
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: 93
- 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 1 guest