Ispirer SQLWays Wizard Guide

Note: Always run SQLWays Wizard Tool using “as Administrator” option. It can be done in Windows Search panel, like shown on the screenshot:

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

Otherwise we cannot guarantee that the tool will be able to extract all the required information from the source database and store it in files on the local machine where you run the migration process.

On the first page of SQLWays Wizard tool we need to enter the license information and provide the project directory.

To register the tool we need to click “Enter License” button and in the opened window click “Read from file”.

After that we need to find the file with the license and open it.

Registration name and registration number should appear in appropriate windows. After that please click “Register”:

After the tool registration we need to provide a project directory. In this directory our tool will generate a project file that will store information about the current migration process.

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

Here 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 SQLWays Wizard tool you need to install the ODBC driver and tune the ODBC connection to the database that should be migrated. Some additional information about the ODBC driver installation and configuration can be found here: 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 Database User Privileges

To be able to make an import into a target database, please choose the required database from the list of the supported databases. Then specify correct information about the target database, for example, server name, database name, user name and a password.

This information will be used by our tool to generate correct command lines to the native utilities of the target database.

The next step is to specify objects for conversion from the list of objects that our tool was able to extract from the source database. To select objects you can just drag-n-drop the required objects to the right pane of the tool. Or you can select the objects using the buttons at the bottom of the tool:

Refresh Object List

If during the migration process the list of objects was updated, for example some additional objects were created or dropped from the database, you can refresh the list of extracted objects. To do that just right click the required object type on the “Database” branch and click “Refresh” button, like it is shown on the screenshot:

If required you can specify different options that can be used to customize the conversion process. These options can be found on the “Specify DDL and Data Options” page:

After that you will need to specify an Export Directory. This is the directory where our tool will put all the generated files, like sql files with the converted code, txt files with the data, bat or sh files with the commands to the native utilities.

Here we need to specify the Bin Directory. This is the path where a native utility of the target database is stored on your local machine where Ispirer Migration and Modernization Toolkit is installed. It means that to be able to make import into the target database you need to have the native utility installed on the machine where you run the conversion.

For more information about databases and their native utilities that will be used by our tool, please refer to this link:

Databases and their native utilities

After all these steps we need to run the migration. Migration process itself consists of two steps: “Conversion” and “Import”. During the conversion step our tool extracts information about the objects specified for conversion, converts them and generates an appropriate set of files. During the import step our tool tries to create all the converted objects and data in the target database.

To run the conversion process we need to click “Start Conversion” button on the “Conversion” tab of the “Migration Status” page:

After the conversion process is finished, we need to run the import process. So we need to go to the “Import” tab and click “Start Import” button to initiate import process.

After the migration process you can review all the generated files in the export directory by clicking “View Export” button on the “Conversion” tab. This button will open a folder that stores all the converted results together with the log files - sqlways.log and sqlways_imp.log files. Sqlways.log file stores detailed information about the conversion step and sqlways_imp.log file stores information about the import process.

These steps describe how to perform database conversion in Ispirer SQLWays Wizard tool. If you have some questions or face any difficulties please contact our support team and provide log files ( sqlways.log and sqlways_imp.log files ) together with detailed description of the case you faced:

More about Ispirer Systems