How to sync Sqlite Database with Remote Database?

Data Migration: How to keep two database models in sync?

• I have an Oracle database I need to keep the models in sync (the same) with a postgresql database, How do I do this? Also the table names are different between the two servers.

• Answer:

  Ideally, you write the scheme using a common subset of SQL DDL. Then you use that scheme files to load the databases. This way you schema is always uniform against the common subset. In your case, you can only do this if you recreate the database with common table names. If you don't want to recreate the names you can run a script to find and replace the table names (sed) before reloading it into the other database. In this case, what you refer to as model is a common schema. However, if you are talking about keeping "content" synchronize and not the actual database schema. It is possible to export the content periodically as a common subset of SQL DML then load into the other database periodically (dump-flush-load). Not elegant but possible. Another possibility is to use a commercial database synchronization tool (ie. Oracle Golden Gate, SymmetricDS, the IBM equivalent).