Copying databases to remote locations

Copying databases to remote locations

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?


Postgres replication
Replication is the "right" way to go, so if migrating to another database is an option (is it really?), that's the best route..
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

88 out of 100 based on 48 user ratings 598 reviews