iphoneiossqlitesqlitemanager

SQLite Manager - Copy table to another .sqlite database

Working on my first iOS App with SQLite database. In Project I have 2 Database, in which First Database is having only one table and the another one is working as a main database. I want to merge those databases into one (the Second one), by copy the table from first database to second database. The First database Table contains more than 32K records. So, I want to copy the entire table with Data.

I want to achieve this using SQLManager AddOn of firefox.

Any Idea?

Solution

  • Instead of SQLManager, You can simply do this with one command line:

    $ echo '.dump tablename' | sqlite3 sourcedb | sqlite3 destdb