I have five remote sites on point to point connections with the head office.
The point to point connections is very fast - a ping rely time of 2-7ms.
Each site has a sql server database ,and so does the HQ.
Because the point to point connections does go down from time to time , I want to set up merge replication so that users can work locally and then have an sql agent job to trigger the synchronization at scheduled times.
My question is in two bits -1,is the the best approach?
2)if the p2p link goes down while the job is synchronizing - will there be data inconsistencies - and how can i best handle that?