Synchronization over VPN?

kbossekbosse Posts: 8
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?

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.
This discussion has been closed.