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

how do I specify different instances in command line?

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"
thu
0

Comments

3 comments

Sort by
  • aolcot
    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.
    aolcot
    0
  • thu
    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
    thu
    0
  • aolcot
    hi thu, Can you provide the full command line that you are using during the compare process please?
    aolcot
    0

Add comment

Please sign in to leave a comment.