We have two servers in two diffrent sites conected by an always on 2mb link. I want to be able to have the users in the different sites to read and write to there own server and then for the data to be replicated to the other. I am thinking merge replication is best for this but does anyone have any other ideas and what would the latency would be.
Latancy varies on the capacity of the machine and the network you are running. Other than Merge Replication, there is another option called Updatable Transactional Replication, which I think it's better than Merge in many cases.