On the Welcome page, you should specify the project directory where the sqlways.log file with the log of the assessment process and reports will be saved. By default the project directory is /Documents/Ispirer/Ispirer Assessment Wizard 10/.

If you want to change the project directory, make sure that you have access to it. In other cases, we can't guarantee that the reports will be saved properly.

Next, we need to choose the ODBC connection to the source database that needs to be assessed. Also specify the user and password that will be used to connect to the source database.

Please note: Our tool only works using an ODBC connection to the source database! This means that before running Ispirer Assessment Wizard, you need to install the ODBC driver and set up the ODBC connection to the database that is to be analyzed by the tool.

Please note: The user specified on this page must have appropriate rights to select system tables from the source database. For more information about source database user privileges, see the appropriate section for your source database.

On the Choose a Target Database page, you need to provide information about your target database. This information will not affect the assessment speed or its assessment effectiveness.

On this page you can specify:

• Target - name of the target database in your project;
• Product - product name, for example LUW, AS400, ASE, ASA, IQ & etc.;
• Version - version of the target database.

This page allows you to select objects for assessment.
To select objects for assessment, you can use the arrow buttons below the window or simply drag objects from the left side of the page to the right.
You can move a single object, an entire schema, an entire object type, or an entire database.

On this page you need to enter the size of the database data manually.

On this page, you need to click on the “Execute” button to start the assessment process, and our Assessment Wizard will collect information about the objects selected for analysis.

On the Execution page, you can check how the assessment process is progressing.
The tool displays each object as it collects metrics and provides overall statistics at the end of the log.
The same information can be found in the sqlways.log file in the project directory.

Here you can see a summary of the assessment containing the DSN name, selected objects and a link to a report with all the details of the assessment.
Similar information can be found in the “reports” folder in the project directory. There is a set of html files containing metrics.

Please send the entire “Reports” folder to our business managers for analysis.
This folder is located in the assessment project directory, you can open it by clicking the “Show in folder…” button.
FYI: The default project directory is /Documents/Ispirer/Ispirer Assessment Wizard 10/.

These steps describe how to generate assessment reports for a source database using Ispirer Assessment Wizard.
If you have additional questions or encounter any difficulties, please contact our support team: support@ispirer.com