I developed an ERP (using VB DotNet 4.0 Windows Application with backend as MySQL)
This application is using by various branches (nearly 8 branches)
Note: Its an windows application but the DB is in server - so, that all the branches will get the live data.
(I should go with web application - but my client is not willing to go with web application)
Now, My client request me to give a solution to run the application even during the time they won't have net connection.
(Receipts and invoice should not be stopped at any moment and what ever reason)
But they are ready to handle with one day old database.
So, we came to a solution as:
Every day all branches have to download the data base from server and work with the same in local machine.
and End of every day all branches have to upload the database to server.
(Note: i have to write a module to merge all branch data while uploading in server)
Note: Currently the size of MySQL db is 70MB
(i hope if we do through coding: downloading and uploading will take long time right? )
My current idea is:
I have to fetch all tables using "select * from tablename" and store the same in strong dataset.
and then insert tables from storng dataset into local db. and finally give option to work with local db.
I have to fetch all tables with records having branch code using "select * from tablename where branchcode=mybranch"
and store the same in storng dataset and insert the same to server db.
Any way i feel it will be required more time to complete this process every day.
I request your valuable best suggestion to do this.
Expecting your valuable reply.