Sql Sync over internet
What is the best solution to sync tables between Servers over the internet?
Situation is that there is one SQL- Server lets say "Main", and a lot of SQL-Servers "Crowd", which all got the same Database with identical Tables for local work.
So I want to sync a few tables of the "Crowd" to the "Main" only one way Crowd -> Main
Option 1: linked server with triggers (bad solution... )
Option 2: Replication which is not that easy cause the Crowd is all local
What is the best solution to do that?
What is the best solution to sync tables between Servers over the internet?
Situation is that there is one SQL- Server lets say "Main", and a lot of SQL-Servers "Crowd", which all got the same Database with identical Tables for local work.
So I want to sync a few tables of the "Crowd" to the "Main" only one way Crowd -> Main
Option 1: linked server with triggers (bad solution... )
Option 2: Replication which is not that easy cause the Crowd is all local
What is the best solution to do that?
No comments:
Post a Comment