How can we help you today? How can we help you today?

First time use of SQL Compare caommand line

Hi,

Need to compare the structure & objects of three satellite databases with a single master database and thought I would try the command line version.

Few questions:

Can I run the comparison from a single machine and access the databases on different server?

Database instance is called Biriani\Biriani and two databases are called Wh1 & Wh2, do I specify it like this...

sqlcompare /Biriani\Biriani:Wh1 /Biriani\Biriani:Wh2


Are the SQL instances & database names case sensitive?

Thanks in advance

Dave
davidmgray
0

Comments

2 comments

Sort by
  • David Atkinson
    If you type sqlcompare.exe /? /v /html > help.html and open help.html in a browser, you'll be able to see all the available options.

    I think the syntax may be more like:

    sqlcompare /s1:Biriani\Biriani /db1:Wh1 /s2:Biriani\Biriani /db2:Wh2

    If you need to synchronize as well as just compare, add the /synch switch.

    David Atkinson
    Red Gate Software
    David Atkinson
    0
  • RogerHart
    You can also find more detailed information about using the command line, including some worked examples, in the online help for SQL Compare:

    http://www.red-gate.com/supportcenter/C ... 547547.htm
    RogerHart
    0

Add comment

Please sign in to leave a comment.