Question: how to copy data from one database to another in sqlite?
Answer: Using SQL query. First you attach database new_db with old_db to associate them in the current database connection. Assume that you are connected to the old_db , now run the ATTACH command to attach the new_db : ...  Using SQLite command-line tool. Open the old database then dump the table.