How to synchronize structurally identical MSSQL databases lying on different servers?

Question

replication

There is a program that works with the MSSQL database (large...hundreds of related tables). The program works in the local network of the enterprise. There was a need for the same program to work on another network, not connected in any way with the first one, perhaps even on a separate computer outside of any networks. The whole system is installed once again on a separate server. Data is entered, edited, deleted in both databases. Is it possible in these conditions to somehow synchronize the data in these databases? It is clear that this will not work completely in automatic mode. But how is it actually done?

Answer 1

This is called Offline Replication . Or offline replication . Or google .