This is an old revision of the document!



Ispirer Home Page Ispirer SQLWays Migration Product Page Request SQLWays

Ispirer Migration and Modernization Toolkit Description

Ispirer Migration and Modernization Toolkit was designed to simplify the database and application migration. This toolkit consists of 3 tools:

Main tool that is used for database migration purposes is Ispirer SQLWays Wizard tool. The idea of this tool is that it is able to connect to the source database using the ODBC Connection. Besides, SQLWays Wizard is able to connect to source database on the local server as well as on the 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 our tool connects to the source database with the ODBC connection, extracts all the required information about the objects that were specified for the Conversion process and converts them. Converted sql code is stored in the sql files on the local machine, where the Wizard is running.

And the second step is - Import. During the 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). And using these native utilities it loads all the converted sql code and extracted data into the target database.

Simple schema of the database migration process using the Ispirer SQLWays Wizard Tool:


Ispirer Home Page Ispirer SQLWays Migration Product Page Request SQLWays


© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.