Options

Command line login to database

AndreQ1AndreQ1 Posts: 8
edited February 21, 2017 6:54PM in SQL Data Compare 11
I'm trying to generate a command line to compare two databases, but when I use the command below, I get the error that "a network-related or instance-specific error occurred while establishing a connection. The server was not found"

The examples in the online documentation (https://documentation.red-gate.com/display/SDC10/Simple+examples+using+the+command+line#Simpleexamplesusingthecommandline-Schedulingacomparison) don't mention the server. How do I specify the server and the login to use?

SQLDataCompare.exe /database1:RedGateTest1 /database2:RedGateTest2
· Share on Twitter

Comments

  • Options
    AndreQ1AndreQ1 Posts: 8
    After looking at SqlDataCompare /? I found the solution to this with the following. There are other flags for passwords and such. The helpfile was very helpful.
    c:Program Files (x86)Red GateSQL Data Compare 12SQLDataCompare.exe  /Server1:YourServer1 /database1:SourceDatabase /Server2:YourServer2 /database2:DestinationDatabase
    · Share on Twitter
Sign In or Register to comment.