I have 4 units spread over different geographical location within a distance of 100KM radius. We want to deploy an hospital information system across all the 4 locations. We need to design deployment architecture for the same .
I need the following information from the experts
Which one of the following is better and pros and cons of the same.
1. Having a single sql server database instance at a cartelized location (datacenter) and make clients at all the 4
locations connect to single instance
2.. Have a separate database instance at each location.
( There are around 700 clients from all the locations put together (Loc1 - 425 clients, loc2 - 50 , loc3 - 25 and loc4 - 200).