Connecting to a database on a remote server

Forum for users of SQL Compare schema synchronization utility

Connecting to a database on a remote server

Postby joeS888 » Thu Sep 05, 2013 8:06 pm

Hi there,

I'm trying to synchronize my databases between our development environment and our staging environment.
Currently, SQL Compare 10 and SQL Data Compare 10 are installed on our development server. When I open any of the two tools, I can select the SQL server(s) on the development environment.

I was wondering if anybody can help me with step by step instructions on how to be able to view the SQL server(s) on my staging environments??

Posts: 1
Joined: Thu Sep 05, 2013 7:59 pm

Postby Brian Donahue » Mon Sep 09, 2013 1:38 pm

If this is a question about the list of SQL Servers that appear in the dropdown, the answer is SQL Compare/Data Compare/Packager can only pick up SQL Servers on the local network, or ones with a service record in your DNS, or ones that have an alias set up on the local computer. If you are going across networks, you can type in the name of the server, but it's not going to find them automatically.
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 1 guest