For the purpose of synchronizing data in sql server, such as:
1. Synchronize data between servers and client
2. When loss of internet, the client can still work based on the data required to run on the client.
3. When have the internet connection, data from workstations to be synchronized with the server.
To meet these objectives above how to do it with sql server? Or other data synchronization?