First time use of SQL Compare caommand line

davidmgray · February 20, 2009 12:19PM

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 · February 20, 2009 1:15PM

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 · February 24, 2009 9:20AM

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

First time use of SQL Compare caommand line

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk