We have one server and more 20 clients. Synchronization between server and clients realize via WCF. Application working many time, but now on any clients Internet connection - unstable. But data from server must be transfer.
On server we have SQL Server 2008 Standart, on all clients - SQL Server 2008 Express R2.
What is best way for transfer data additional via SQL Compact database file or may be there is other ways for offline transfer data?
I'm afraid what may be broken timestamps on clients and server when we will be use offline transfer. Many tables exchange bi-directional between server and clients.