How can i sync offline database and online database

Question

How can i sync offline database (SQLite) and online database (MySQL) using C#? Basically i want to sync my online database (web server's database) with my local database (which on Hard-disc )database and vice-versa. If i add a new data on my online database it automatically and on my local database (when click sync button as well as if internet connection available)

Nitin Sontakke · Answer

Fairly a complicated job. You need to look into primary keys foreign keys all data modifications such as insert / update and delete to keep in sync. If one db is changing and you want to keep another in sync that is fine. However two way sync is pretty much a project by itself. Technically this is not a C# work try to see if scripts in native db would do the job. C# would come into picture if you want to call scripts at click of a button.