0

I would like to replicate between 2 sql servers that exist in different networks. This link is not relevant to my case as the servers are not connected: https://docs.microsoft.com/en-us/sql/relational-databases/replication/tutorial-replicating-data-between-continuously-connected-servers?view=sql-server-2017

If we assume that I can get the first copy of the database and then move it to the new server, in order to set up transactional replication, is it necessary that I use a vpn?

I have checked these links but were of no help:

SQL Server Transactional Replication over Internet

SQL Server replication over internet error

Is there a tutorial somewhere on 1) How to do replication over the internet 2) How to do replication if a vpn is required?

More info: The source would be a sql server 2014 and the destination a sql server 2016.

  • Connecting the two servers over the Internet--there's no way any of us can tell you what will be required. This may require multiple firewalls to be configured, etc. As for a VPN, it's not required, but if you don't use a VPN then you are exposing the data to anyone that has access to the networks that have to be traversed to get from point A to point B. – Tony Hinkle Feb 14 '19 at 15:56
  • @TonyHinkle Thank you. In my case, there is 1 firewall protecting the one sql server, and one firewall protecting the other one. I should allow port 1433 for these 2? – Jason Feb 14 '19 at 17:11
  • Yes, but I would highly recommend only allowing 1433 for the one IP address the traffic will be coming from on the other end. If you allow any IP address through on port 1433, you're opening SQL Server up to hacking attempts. You need serious security hardening here. docs.microsoft.com/en-us/sql/sql-server/install/… – Tony Hinkle Feb 14 '19 at 17:21
  • @TonyHinkle Is there a tutorial for setting the connection up through SSMS? – Jason Feb 14 '19 at 17:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.