how do I specify different instances in command line?

thuthu Posts: 3
edited August 31, 2011 8:53AM in SQL Compare Previous Versions
Hi,
I am trying to create a SQLcompare script using command line. However, I have multiple instances on the same server. How do I specify that in the command line? Everything I try so far gives me error bellow. Please help me get around this problem. Thanks,
Thu


"Serial Number: 507-001-153093-6433

Registering data sources
Error: Comparison of '.Admin1' and '.Admin2' failed: A network-related or
instance-specific error occurred while establishing a connection to SQL Server.
The server was not found or was not accessible. Verify that the instance name iscorrect and that SQL Server is configured to allow remote connections.
(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL
Server)
SQL Compare Command Line V9.0.0.79"

Comments

  • aolcotaolcot Posts: 27 Bronze 1
    Hi thu,
    You can use the parameters /s1 and /s2 to point to different instances e.g.

    SQLCOMPARE /s1:mysqlserver\instance1 /s2:mysqlserver\instance2 /db1:mydb1 /db2:mydb2

    Hope this helps.
  • Hi aolcot,
    Thank you for your response. I used the /s1 and /s2 for the server and instances, but that still gave the same error. Did it work for you?
    thanks,
    Thu
  • aolcotaolcot Posts: 27 Bronze 1
    hi thu, Can you provide the full command line that you are using during the compare process please?
Sign In or Register to comment.