2. How it Works

Working Steps

  1. In the Start menu, go to All Programs >> SQL LOG Analyzer. A window like this will pop up on screen:
    nnstall
  2. In the navigation bar at the top, click on 'Open' button to add file.
    open option
  3. Now Browse the file.
    browse
  4. Select the file from system (at once only one file can be selected). Click Open.

    5. select file
  5. If location of LDF and MDF file is same, the software will automatically detect the MDF file. Else, the user has to browse for the MDF file location.
    automatically detect
  6. The software will start scanning the selected file and once scanning is done, a message about the same will be received on screen. Click OK.
    complete scanning
  7. A scanning report will be displayed within the tool.
    preview
  8. From the left panel of software, a table can be selected and its corresponding details will be available in right panel.
    view details
  9. The type of transaction can be sorted accordingly.
    sort transactions
  10. The file can be sorted according to time when it was updated.
    sort time
  11. The file can be sorted according to table name also.
    sort table name
  12. The file can be sorted according to the name of transaction.
    sort transactions name
  13. The row and details of the selected transaction can be viewed at bottom of right panel.
    preview row
  14. The tool gives the option to export the tables from log file. Select the tables to be exported from left panel.
    select elements
  15. Click on the 'Export' button from the navigation bar at the top to start exporting the tables.
    export
  16. The tool gives three options to export the log tables. If 'SQL Server Database' is selected, the tables will be saved in an MDF file which can be directly saved on Server. Also, the Database Credentials column has to be filled.
  17. If 'SQL Server Compatible Scripts' is selected, chose a destination location on local machine where '.sql' file will be created.
  18. If 'CSV' file is selected, the details of selected file will be exported into a .csv file.

    19. export database
  19. Select record types which want to export.
    record types
  20. Filter & the records according datewise.
    filter datewise
  21. Browse for a location where SQL Server compatible scripts or CSV file has to be saved.
    browse location
  22. Select the location and click OK.
    select location
  23. Click on Export button to start saving process.
    click export
  24. A status regarding the export process completion will be displayed on screen.
    export process
  25. Click OK when message regarding successful export is obtained on screen.
    completed process