First time use of SQL Compare caommand line

davidmgray

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

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

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