Hi, I am not an SQL expert, but have to set up 3 remote SQL databases that need to be synchronised with each other.
This is unusual because the locations are tiny atolls in the middle of the Pacific. Communication between them is by satellite only which has limited bandwidth and is expensive. The total population (thats all the people) on each atoll is only
500. There is likely to be a maximum of 40 potential users per atoll and each SQL database is for internet login authentication only (Radius). So the databases are tiny and have a very low update rate.
What is the simplest way to synchronise the databases? Doing this just once each night at around 4:00am would be best.
Peer to peer replication sounded right, but I do not want our extremely limited bandwidth taken up by this traffic when all we need is for the databases to be synchronised by the next day. Also we are running MS SQL 2008 R2 Workshop edition and I am
reading that this does not support peer2peer replication.
The hardware is a laptop - since hot moisture laden salty air is very corrosive for traditional servers and power is intermittant at best. Each atoll gets an identical system.
Can anyone suggest a solution or ideas? I am happy yo answer questions. Thank you.
View Complete Post