How to take backup and Restore Selected Rows from SQLite DB RRS feed

  • Question

  • Hi

    I wanted to take the backup of selected Rows from a sqlite table and write it back when restored .

    I tried to converting the table to .csv and restore ,but it didnt work as the whole table is converted to .csv and while restoring 

    it loose the datatype  of the column.

    Help me how to do a backup of selected rows and then restore it back with out loosing the type of the columns.

    Is there a standard way / existing design to do this?



    Friday, October 11, 2019 5:04 PM


All replies

  • Wrong forum. This forum is specific to Microsoft SQL Server. You should post your question to a forum specific to SQLite or a general developer forum like StackOverflow
    Friday, October 11, 2019 5:07 PM
  • Hi SomarajK,


    It seems that your issue is more related to SQLite. Would you please try to ask for help on the SQLite forum.


    Best regards,

    Dedmon Dai

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact

    Monday, October 14, 2019 6:49 AM