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
database
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