locked
How create online synchronization with offline together RRS feed

  • Question

  • 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.  

    Tuesday, June 19, 2012 11:10 PM

All replies

  • you can create an SDF from your clients, sync that SDF to your client's SQL Express, send the SDF offline to your server location, sync the SDF to the Server.

    if you need to send back changes to the client, just send the SDF back and sync it back to the SQL Express.

    Wednesday, June 20, 2012 8:36 AM