MS SQL (Windows) replication/synchronization, which architecture to use?

Question

Microsoft

It is necessary to be defined with architecture and software (under Windows).
1.
"Layer 1" (LAN)
"Layer 2" (LAN)
"Layer 3" (Internet)
i.e. "Level 1" and "Level 2" work within the local network, and "Level 3" is located on the Internet
2.
At each level of the database with an identical structure
3.
The levels must work autonomously (for reading).
4.
There are 2 (4) types of
tables 4.1 TBL1 can only be changed to "Level 1".
those. "Level2" and "Level3" can only change this table when available (there is a connection) with "Level 1"
optimally, "Level2" and "Level3" are changed directly in the "Level 1" database; if it works, then update "Level2" and "Level3" in the database ("Level2" and / or "Level3" may become unavailable, so the update should go after restoration communication)
4.2 TBL2 changes only to "Level 1"
i.e. data is written to the table only from "Level1" after writing, they need to be updated to "Level2" and "Level3"
4.2.1. if updated to both "Level2" and "Level2" delete from "Level1"
4.2.2. if updated to both "Level2" and "Level2" can be removed from "Level1" partially
Replication MS SQL - very difficult to configure, and the database needs to be deployed from a script or batch file.
As a result
, it is necessary to obtain identical databases at all 3 levels if there is a connection everywhere.
- change certain tables only at a certain level
; - delete information at a certain level; to stay with the others.

Answer 1

I will try to shorten your text: for some tables you need master-master replication, for others - master-slave, unless of course I understand correctly. Let's discuss this:
> MS SQL replication - very difficult to set up
Well, apparently it is difficult because it supports many different scenarios. Why did you decide that your bike would work better? Moreover, you do not choose a DBMS, it is already installed and working for you.
Of course, there is also third-party software, for example www.symmetricds.org , but it is very likely that you will rake all the bumps from its use.