0 Replies Latest reply: Nov 10, 2014 2:43 AM by jameel flex RSS

    How to partially copy a SQLITE database/table

    jameel flex Community Member

      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