how do I specify different instances in command line?
thu
Posts: 3
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"
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
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.
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