Click here to Skip to main content
15,112,198 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have database hosted on server MySQL and i need to develop synchronization for windows application when the internet is not active all data should go to my local database i.e mysql , and when the internet is actve it should synchronize all my data from offline to online database tables automatically in the background. Here the main concern is not to loose any data. How should i achieve that. Please help. Thank you!

What I have tried:

No i don't have any idea about it. I am just a fresher
Posted
Updated 21-Jun-18 21:39pm
v2
Comments
Richard MacCutchan 22-Jun-18 3:13am
   
You will need to keep track of every inserted and updated record in the local database, and apply the same changes to the online version.
Member 13882518 22-Jun-18 6:49am
   
Thank you sir!!
Mike V Baker 22-Jun-18 14:16pm
   
Since your database is on a remote server should we assume that there will be multiple clients using it? That opens up another possible issue.. when one client is online and another is offline. Client A might be updating while client B is offline and client B won't have any knowledge of the updates made by A when it comes back.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900