Ispirer Assessment Wizard for Databases
1. Welcome Page
On the Welcome page you should specify the project directory where sqlways.log file with the log of the assessment process and reports will be saved. By default the project directory is “C:\Users\[User Name]\Documents\Ispirer\Ispirer Assessment Wizard 10”.
If you want to change the project directory, make sure that you have access to it or restart the tool with the right click and choose “Run as Administartor”. In other cases we can't guarantee that the reports will be saved properly.
2. Choose a Source Database
Then we need to choose the ODBC connection to the source database that you need to assess. Please also specify a user and a password that will be used to connect to the source database.
Please note: Our tool works using the ODBC connection to the source database only! It means that before running Ispirer Assessment Wizard tool you need to install the ODBC driver and tune the ODBC connection to the database that should be analyzed by the tool. Some additional information about the ODBC driver installation and configuration can be found on this page: Setting Up Database Connection
Please note: User that is specified on this page should have appropriate rights to make selects from system tables from your source database. More information about source database user privileges can be found on this page: Setting up Source User Privileges
3. Choose a Target Database
On the next “Choose a Target Database” page you need to specify information about your target database. This information will not impact assessment speed or assessment performance.
On this page you can specify:
- “Target:” - name of the destination database in your project;
- “Product:” - product name, like LUW, AS400, ASE, ASA, IQ & etc.;
- “Version:” - version of the target database.
4. Objects Page
This page allows to select objects for assessment.
To select objects for assessment you can use arrow buttons under the window or simply Drag&Drop the objects from the left to the right page.
You can move one object, the whole schema, the whole object type or the whole database.
5. Specify Options
On this page you can set additional options.
Data size
This option allows to specify data size in Gigabytes. If nothing is specified here, the tool will collect information itself, but this process may take time.
6. Review the Selection
On this page we need to click “Execute” button to start assessment process and our Assessment Wizard will collect information about the objects selected for analysis.
7. Execution Status
On the “Execution Status” page you can check how assessment process is being performed.
The tool depicts each object while collecting the metrics and provides total statistics at the end of the log.
The same information can be found in sqlways.log file in the project directory.
8. Completing Page
Here you can see the assessment summary information containing the DSN name, selected objects and the link to the report with all the assessment details.
Similar information can be found in the “reports” folder in the project directory. There is a set of html files that contain the metrics.
Please send MigrationAssessment_Report.html file to our business managers for analysis.
9. Other Questions
These steps describe how to generate assessment reports for the source database using Ispirer Assessment Wizard tool. If you have any additional questions or face any difficulties please contact our support team: support@ispirer.com