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

Command line login to database

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
AndreQ1
0

Comments

1 comment

Sort by
  • AndreQ1
    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
    AndreQ1
    0

Add comment

Please sign in to leave a comment.