Synchronization over VPN?

kbossekbosse Posts: 8
edited June 26, 2006 11:07AM in SQL Data Compare Previous Versions
We have a program that requires synchronization of a local SQL DB with a remote DB in a central location. Is it possible for the remote and local DBs to see each other and sync over VPN with Data Compare? Has anyone tried it before?
· Share on Twitter

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hello,

    I'm under the impression that this setup is not that uncommon. As long as you can get a SQL query through the VPN pipe, it should work the same as if you were on the local network, albeit slower.

    If the discovery isn't automatically picking up the server name and putting it in SQL Compare and Data Compare's dropdown list, you may need to reference it by manually entering the IP address or create an alias using the SQL Server client network utility and enter the alias name into SQL Compare's server box.
    · Share on Twitter
This discussion has been closed.