We have the following scenario:
We have several SQL serves instances in distributed geographic areas (distributed buildings) (in a city or maybe globally)
All the SQL servers run one snapshot of a database
The databases should be synchronized (maybe with peer to peer replication or other alternatives)
All computers in a building connected to the SQL server that is located in the building
Connection between buildings maybe lost (for a day for example) and after servers reconnected data should be synced and all the SQL servers should have same data (and we should taking care of conflicts absolutely)
How we can handle this scenario?
(I am not a SQL server expert so it would be nice of you to explain it in more details)