Our EPOS system copies data by compressing the database into a zip file, and manually copying to each till, using shared directories.
Each branched is liked to the main location, using VPN which can be problematic, but is required for the file sharing to work correctly.
Since our database system currently does not support replication, is there another solution for copying data or should we migrate our software to another database?
How can I merge many SQLite databases?
What's wrong with foreign keys?
You might consider a utility that queries all the tables for raw data (in CSV?), sending that to files.
How to best search against a DB with Lucene?
Then at least you don't have to take the database down to do the backup..
What's a good way to store raster data?
How do you manage “pick lists” in a database