hi folks!

I went through the following for one server replication process:


The actual scenario is one of my server is in UK behind NAT, one in UAE behind NAT (where I am), third in South Africa

UAE is a factory, so they process/pack and update new items from here, while UK and SA are sales, so they have only specific table to replicate.

All have data to share between others, because each office has a desktop front end, I need to replicate the between the each others.

We have acquired a server, on a public IP address in a datacenter, with MSSQL installed, I want that server to act as a central server. where all data merges and replicates every where.

can any one guide me how to solve this?