Ispirer Ispirer

Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays

How to Use the Assessment Wizard Tool for Databases

Run the Assessment Wizard as Administrator

Note: Always run the Assessment Wizard Tool using “as Administrator” option. You can do it using Windows Search panel, like it is done on the screenshot:

Or you can go to the installation directory, right click on the icon and choose “Run as Administration”.
By default installation directory look like “C:\Program Files (x86)\Ispirer\MnMATK2017”.
Please see the screenshot for your reference:

In other case we can't guarantee that the tool will be able to extract all the required information from source database and store it in files on the local machine, where you running the assessment process.

1. Welcome Page

On the first page of the Assessment Wizard tool we need to provide the project directory.

1.1 Project Directory

After the tool registration we need to provide the project directory.

Once the assessment is completed, this folder will have a sqlways.log file with the log of the assessment process and a “reports” folder with html reports about the assessment process.

Please note: you can get the demo license of this tool at our official web site

2. Choose a Source Database

Then we need to choose the ODBC connection to the source database that should be migrated. And 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 using the 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 Assessment wizard. Some additional information about the ODBC driver installation and configuration can be found on that page: Setting Up Database Connection

Please note: User that we specify on that 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 that page: 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 for your project;
  • “Product:” - product name, like LUW, AS400, ASE, ASA, IQ & etc.;
  • “Version:” - version of the destination database.

4. Choose a Target Database

This page allows you to select objects for the assessment.

To select objects for the assessment you can use arrow buttons under the window or simply Drag&Drop the objects from left to right pane.

You can move one object, the whole schema, the whole object type or the whole database.

5. Specify Options

You can set additional options on this page.

Data size

This option allows to specify data size in Gigabytes. Or the tool will collect information itself, but this process may take a time.

6. Review the Selection

On this page we need to click “Execute” button to start the 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 performing.

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 report in table format showing information on the number of objects, their types (Tables, Views, Stored Procedures & etc.), the number of lines of code and the size of data, and etc.

Similar information can be found in the “reports” folder in the project directory. There is a set of html files that contain the metrics.

Information that is stored in the html files should be sent to our business managers for analysis.

Other Questions

These steps describes how to generate the assessment reports for the source database, using the Ispirer Assessment Wizard tool. If you will have some additional questions or face with some difficulties please contact our support team and provide detailed description of the case you faced with:

Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays

sqlways/how-to-use-migration-assessment-wizard.txt · Last modified: July 27, 2018, 11:35:42 AM by alexandr.kirpichny
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement