As I show in the picture , I have three database servers (different town location) and client computers each one is running software.
Database schema for those three servers are same. And now I have to synchronize those three servers.
So I upload the database to smarterasp.net. I want to access this database from different local server and synchronize every Transaction ( Insert,Update,Delete ).
I found SQL Server Replication and there are three types of replication
- Transactional replication
- Merge replication
- Snapshot replication
What approach should I use for this ?
Or any other way which is more suitable ?
Note: Sometime , the local server may be offline due to the condition of internet connection.