Add new servers
gbritton
Posts: 17 Bronze 1
When I launch SQL Data Compare, I cannot see all the servers I want to compare. How do I add a new server to the list presented?
Comments
Next issue: two servers that I want to compare are in different domains and the domains don't trust each other. I use different IDs for each domain to login to the servers. How can I set up the project so that I can compare these two servers? Assuming one of the servers is in the same domain I run the project from, I would need a place to put in the Windows credentials for the other domain and SQL Data Compare would need to use those credentials for that connection?
Can that be done?
Also, can I specify a linked server as the Compare To server?
I think for a linked server you would just have to specify the server/instance name directly
So if serverainstance1 has a link to serverb:
Compare: serverainstance1 to: serverainstance1.serverb
Where serverb is the name of the linked server?