Online and offline point of sales application

Question

I am going to develop a simple Point of Sales system. Mainly all the data will be stored in a central db (mysql server). All the application are going to be window application. Together each local client will have its db copy that will be SQLite stored locally and all the operation will be based on the local db. So at certain interval there will be updates from the local db sqlite into the central db MySQL. window application in c# How I can implement it.

Akshay Phadke · Answer

you just need to create a service that will fetch the records from database ie mysql db it will fetch records from that service and it will get restored that ata in sql lite in this way you will able to sync the local copy of data .

Vinay Singh · Answer

Hi Try the below links https://www.quora.com/What-is-the-best-way-to-copy-my-SQLite-database-to-PostgreSQL-so-I-can-deploy-it-to-Heroku http://www.codeproject.com/Questions/464556/How-can-I-convert-MySQL-database-to-SQLite-using-P