Ispirer Migration and Modernization Toolkit Description

Ispirer Migration and Modernization Toolkit (Ispirer MnMTK) was designed to simplify database and application migration process. The toolkit consists of 4 tools:

  • Ispirer SQLWays Wizard
  • Ispirer nGLFly Wizard
  • Ispirer Migration Studio
  • Ispirer Migration Commander

Ispirer SQLWays Wizard is the main tool, which is used for database migration purposes. The tool is able to connect to a source database on a local server as well as on a remote server, using an ODBC connection.

The whole migration process is performed in two steps: –°onversion and Import. The first step is Conversion. During the Conversion stage the tool connects to the source database using ODBC connection, extracts all the required information about the objects that were specified for the Conversion process and converts them. The converted SQL code is stored in the SQL files on the local machine, where SQLWays Wizard is running.

The second step is Import. During Import stage SQLWays Wizard connects to the target database using target database client and its command line native utilities (psql.exe, mysql.exe, sqlcmd.exe, sqlplus.exe and others). Using these native utilities it loads all the converted SQL code and extracted data into the target database.

Please find below a simple database migration process schema of Ispirer SQLWays Wizard Tool:

More about Ispirer Systems