How to Do Sqlite Database Recovery and Convert It with SQLite Database Recovery

Step-by-Step Guide

1. 1

   Step 1: Download and open SQLite Database Recovery Software on your PC.

   Choose file and then click OK.
   
   The software will perform the scanning process over the selected database.
   
   Wait for the scanning process to get completed. ,,, The user is now able to see every constituent elements of that SQLite database. ,, Select and click OK. , If the DSN is already exists for SQL Server Compatibility, simply choose that DSN. , An example to create a DSN is provided in the image. , The software will prompt user to provide data type mapping of the database.
   
   Once completed click "OK". ,,, Click "OK". , Click "Close" button. , Now you will be able to safely use your repaired SQLite database.
2. 2

   Step 2: Browse to the corrupt SQLite database file location (File Extension .db

3. 3

   Step 3: .sqlite

4. 4

   Step 4: .sqlite3).

5. 5

   Step 5: Once you get a confirmation message that the scanning process is complete

6. 6

   Step 6: click "OK" to proceed further.

7. 7

   Step 7: After SQLite Recovery Software will gives a summary of the database structure and its associated elements(Tables

8. 8

   Step 8: Triggers etc)

9. 9

   Step 9: click "Close" to proceed further.

10. 10

    Step 10: The user is now taken to screen where in-depth analysis can be done pertaining to the recovered database.

11. 11

    Step 11: Click on "Export" button to save the recovered database.

12. 12

    Step 12: At this point the user has a choice to save the database in SQLite

13. 13

    Step 13: MS Access or SQL Server .mdf file format.

14. 14

    Step 14: If the user wants to convert the SQLite database in SQL MDF file format he needs to click on "Other Database" radio button.

15. 15

    Step 15: If the DSN is not showing up

16. 16

    Step 16: the user needs to create a new DSN before he can export that database in SQL Server MDF File format.

17. 17

    Step 17: The rest of the steps are all common for all three database types.

18. 18

    Step 18: Provide the destination path to save the recovered SQLite database.

19. 19

    Step 19: Wait till the software perform the process of exporting the database.

20. 20

    Step 20: Once the export process is completed the software will greet user with a success message.

21. 21

    Step 21: The last and final step in SQLite database recovery is to read the report that is generated by the software.

22. 22

    Step 22: You can close the application.

Detailed Guide

About the Author