Loading

Online and offline point of sales application

Jagroop Singh

10y1kSQL

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Akshay Phadke10y ago
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 .
0
Vinay Singh10y ago
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
0