How to partially copy a SQLITE database/table

forums_noreply@adobe.com — Mon, 10 Nov 2014 10:43:33 GMT

Hi Everybody,

I have an AIR application which uses a local Sqlite database.

I want to take a backup of my application. For that I have to copy some table data/rows from the database as SQL queries.

Requirement is a user can later import the stored things into the application, during which the copied table/data should be inserted into the new database.

I think retrieving each record individually and making insert query from the values and saving in a text file and then later at the time of importing executing those insert queries one by one

is a really expensive and time taking job. (As I have thousands of records)

Please suggest me an efficient method to do this.

Regards,

Jameel

Adobe Community: Message List - How to partially copy a SQLITE database/table

How to partially copy a SQLITE database/table