Online-Offline Database Synchronization

[Alvin_2]

I am building an online-offline application. The offline applications db should be synchronized with online app db. What I have done so far is, built an offline app with sql ce as backend, and used timer to check whether internet connectivity is available in each 5 minutes. The issue I am having is I am able to add new data into online db from offline db, however I am still not clear on an efficient way of updating data which is already there, I have tried a few methods, but the performance is too bad. Need logic ideas, can anyone help ?

[Mike Askew]

Not entirely sure on the solution myself but a good place to start would be telling us what solutions you have already tried that performed badly :)

[deceptikon]

Have you tried an incremental sync? http://msdn.microsoft.com/en-us/library/bb726021.aspx