For small business, they may have offline database, and these offline database could be excel or access or at least it could be transferred to Excel sheet or Access database.
For their online database, it could be MySQL or Firebird.
What is your solution about keep the offline database and online database consistent?
Any web links, books, articles might give me help?
Are there any tools I can use to update the online database (MySQL, FireBird) from the offline documents (Access or Excel)?
Are there any tools to update online database table 1 by table 2 (I can upload the offline excel or access data to create the table2 for update purpose.)?
Are there any tools I cau use to do the reverse update? Update the offline database (Access or Excel) with a new Access or Excel documments ( which I created by downloading the data from online database and save the data in a new Excel or Access sheet)
