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

This tutorial is for SQLite Database users who want to repair their SQLite database and restore the data in the default SQLite database format or in MS Access, SQL Master Database File (.mdf) formats.

Steps

  1. Image titled Do Sqlite Database Recovery and Convert It with SQLite Database Recovery Step 1
    1
    Download and open SQLite Database Recovery Software on your PC.
  2. Image titled Do Sqlite Database Recovery and Convert It with SQLite Database Recovery Step 2
    2
    Browse to the corrupt SQLite database file location (File Extension .db, .sqlite, .sqlite3). 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.
  3. Image titled Do Sqlite Database Recovery and Convert It with SQLite Database Recovery Step 3
    3
    Once you get a confirmation message that the scanning process is complete, click "OK" to proceed further.
  4. Image titled Do Sqlite Database Recovery and Convert It with SQLite Database Recovery Step 4
    4
    After SQLite Recovery Software will gives a summary of the database structure and its associated elements(Tables, Views, Triggers etc), click "Close" to proceed further.
  5. Image titled Do Sqlite Database Recovery and Convert It with SQLite Database Recovery Step 5
    5
    The user is now taken to screen where in-depth analysis can be done pertaining to the recovered database. The user is now able to see every constituent elements of that SQLite database.
  6. Image titled Do Sqlite Database Recovery and Convert It with SQLite Database Recovery Step 6
    6
    Click on "Export" button to save the recovered database.
  7. Image titled Do Sqlite Database Recovery and Convert It with SQLite Database Recovery Step 7
    7
    At this point the user has a choice to save the database in SQLite, MS Access or SQL Server .mdf file format. Select and click OK.
  8. Image titled Do Sqlite Database Recovery and Convert It with SQLite Database Recovery Step 8
    8
    If the user wants to convert the SQLite database in SQL MDF file format he needs to click on "Other Database" radio button. If the DSN is already exists for SQL Server Compatibility, simply choose that DSN.
  9. Image titled Do Sqlite Database Recovery and Convert It with SQLite Database Recovery Step 9
    9
    If the DSN is not showing up, the user needs to create a new DSN before he can export that database in SQL Server MDF File format. An example to create a DSN is provided in the image.
  10. Image titled Do Sqlite Database Recovery and Convert It with SQLite Database Recovery Step 10
    10
    The rest of the steps are all common for all three database types. The software will prompt user to provide data type mapping of the database. Once completed click "OK".
  11. Image titled Do Sqlite Database Recovery and Convert It with SQLite Database Recovery Step 11
    11
    Provide the destination path to save the recovered SQLite database.
  12. Image titled Do Sqlite Database Recovery and Convert It with SQLite Database Recovery Step 12
    12
    Wait till the software perform the process of exporting the database.
  13. Image titled Do Sqlite Database Recovery and Convert It with SQLite Database Recovery Step 13
    13
    Once the export process is completed the software will greet user with a success message. Click "OK".
  14. Image titled Do Sqlite Database Recovery and Convert It with SQLite Database Recovery Step 14
    14
    The last and final step in SQLite database recovery is to read the report that is generated by the software. Click "Close" button.
  15. Image titled Do Sqlite Database Recovery and Convert It with SQLite Database Recovery Step 15
    15
    You can close the application. Now you will be able to safely use your repaired SQLite database.

Warnings

  • To be on safe side the user are advised to create a backup of their corrupt SQLite database before proceeding further with the software.

Article Info

Categories: Software | Databases