Copy/Merge Plan SQLite database to Encrypted SQLite database

I want to perform copy data from plan database to Encrypted SQLite database but my existing encrypted SQLite database has added table colume which is not present in plain database.

Is it possible to merge plain database to encrypted SQLite database?

How i proceed further to achieve my goal?

Thank you.

Hello @Atul_Bhandare, yes, this is possible but you’ll need to migrate the database data manually. You can start by attaching the the database:

SQLCipher API - Zetetic

Once you have one database attached to the other, you can migrate data, i.e. via INSERT INTO database1.x SELECT columns FROM database2.y;

Hello @sjlombardo ,

Thank you for your response.

Same i am thinking to use it, attach database and then fire insert query.