Create a new SQLite database from an old one

Question

I have a big SQLite database with a lot of tables I don't need (about 200 tables) and 10 tables I want to keep. I want to trim the database as much as I can, because it's going to go into an Android app. So, basically, I want to copy 10 tables from a SQLite database to another database, and discard the rest.

How can I achieve this?

In about 10 seconds of using google I found the following http://stackoverflow.com/questions/10471003/copying-table-in-one-db-to-another-db-in-ios-by-sqlite3 — Andre, May 01 '14 at 08:16

score 0 · Answer 1 · answered May 02 '14 at 07:15

0

Why not to copy the original file using filecopy features.
After that you can DROP not needed tables?
Finally you can COMPACT db.

If you do not need anymore the 190 tables you could avoid the file copy.
;-)

dex

answered May 02 '14 at 07:15

Dex

1
2

Create a new SQLite database from an old one

1 Answers1