Export from a standalone database to an embedded database.

Posted by jdana on Stack Overflow See other posts from Stack Overflow or by jdana
Published on 2011-01-07T18:54:15Z Indexed on 2011/01/08 8:54 UTC
Read the original article Hit count: 147

Filed under:

I have a two-part application, where there is a central database that is edited, and then at certain times, the data is released and distributed as its own application. I would like to use a standalone database for the central database (MySQL, Postgres, Oracle, SQL Server, etc.) and then have a reliable export to an embedded database (probably SQLite) for distribution.

What tools/processes are available for such an export, or is it a practice to be avoided?

EDIT: A couple of additional pieces of information. The distributed application should be able to run without having to connect to another server (ex: your spellchecker still works even you don't have internet), and I don't want to install a full DB server for read-only access to the data.

© Stack Overflow or respective owner

Related posts about database