I have a case where many SQL Server instances need to be merged and centralized in one master database.

This needs to be near real-time solution. After looking around in Google, I've found that transactional replication can do the trick.

The problem is that I have (n) publisher databases, and they don't even have static IPs. I had the impression that push replication will be enough to send the data to the centralized database without knowing about the publisher connection, but it seems like I was wrong.

My question is: How can I set up an solution to merge/replicate multiple publisher databases which don't have static IPs, and might suffer frequent outage from the network, all that in near real-time?

  • if all servers in the same place you can setup private network between all servers to sync. Oct 31, 2016 at 11:22
  • They will be connected using public network.
    – Lamar
    Oct 31, 2016 at 11:37
  • if your machine using DHCP, you can use VPN to connect to each other, but this is a costly solution, since moving a huge data over Internet need a good Internet connection Nov 1, 2016 at 9:22

1 Answer 1


A VPN connection can be used to connect to each other. But moving a huge data over Internet is done using DHCP connection, And may be slower depending on your internet connection.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.