http://www.sqlite.org/lang_attach.html
The above should help. Rather than replacing the database, have a set of tables that are the core information. either, use them attached, or attach your update database, get rid of the old info, and replace it from the new database.
so, for example, if you attach the database as "updates", you can then "insert into infotable select * from updates.infotable"
Hope this helps.




Reply With Quote

Bookmarks