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
0

Comments

2 comments

  • Andy C S
    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 C S
    0
  • Alice E
    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 E
    0

Add comment

Please sign in to leave a comment.