Edit Article

Edited by james mascarenhas

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.

Edit Steps

  1. step one of the process
    1
    Download and open SQLite Database Recovery Software on your PC.
  2. step two- SQLite database location
    2
    Browse to the corrupt SQLite database file location (File Extension .db, .sqlite, .sqlite3). Choose file and then click ok.
  3. step three- Scanning process
    3
    The software will perform the scanning process over the selected database. Wait for the scanning process to get completed.
  4. step four- scanning completed
    4
    After performing the scanning process the software will give a confirmation message. Click "OK" to proceed further.
  5. step five- brief database summary
    5
    The SQLite Recovery Software will give a summary of the database structure and its associated elements(Tables, Views, Triggers etc). Click "Close" to proceed further
  6. analysis recovered database
    6
    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.
  7. Export the database in .db, access or .mdf file
    7
    Now click on "Export" button to save the recovered database.
  8. 8
    choose your database extensionchoose your database extension
    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.
  9. 9
    If the user wants to convert the SQLite database in SQL MDF file format he needs to click on "Other Database" radio button.

    for to convert SQLite database in MDF File formatfor to convert SQLite database in MDF File format
    If the DSN is already exists for SQL Server Compatibility, simply choose that DSN.
  10. Creating DSN
    10
    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.
  11. Data Type Mapping
    11
    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".
  12. 12
    Provide the destination path to save the recovered SQLite database.

    select the locationselect the location
  13. SQLite recovery process
    13
    Wait till the software perform the process of exporting the database.
  14. recovery completed successfully
    14
    Once the export process is completed the software will greet user with a success message. Click "OK".
  15. Export process completed
    15
    The last and final step in SQLite database recovery is to read the report that is generated by the software. Click "Close" button.
  16. repair process completed
    16
    You can close the application. Now you will be able to safely use your repaired SQLite database.

Edit Video

http://www.youtube.com/watch?v=8sQDx1PVCw0

Edit 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

Was this article accurate?

YesNo
x

Thank Our Volunteer Authors.

Follow us on Google+