Connecting to a database on a remote server

joeS888joeS888 Posts: 2
edited September 9, 2013 9:38AM in SQL Compare Previous Versions
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??

Thanks!
· Share on Twitter

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
    · Share on Twitter
Sign In or Register to comment.