Intelligent, Custom and Highly Automated Cross Platform Database and Application Migration

Migrating IBM DB2 z/OS S/390 Mainframe

Ispirer MnMTK converts database schema (DDL), data and server-side business logic from IBM DB2 z/OS (zSeries), OS/390 (S/390) to IBM DB2 UDB LUW, Oracle, Microsoft SQL Server, MySQL and other databases.

This demo shows how Ispirer MnMTK can migrate Oracle to DB2 OS/390 database:

Why Ispirer MnMTK

  • Designed for enterprise databases - capable of dealing with thousands of tables and large volumes of data
  • Full S/390 support including partitions
  • UI and batch mode
  • Concurrent and distributed process
  • Migration validation

Conversion Features

The tool migrates the following database objects and properties:

  • Tables and Data
    • Converts columns definitions - data types, default values, NOT NULL constraints
    • Supports identity columns (sequence and trigger are generated in Oracle)
    • Converts integrity constraints - primary and foreign keys, unique and check constraints
    • Converts comments
    • Migrates Partitions definitions
    • Transfers data (including LOB data types)
  • Indexes, Views and Sequences
  • Stored procedures, Functions and Triggers

Besides server-side business logic, Ispirer MnMTK also converts SQL queries in front-end applications and scripts.

Ispirer MnMTK works with IBM DB2 mainframe databases as a source using the ODBC connection. For information about how to tune-up the connection, please refer to the offline demo below:

For more information, please visit Ispirer MnMTK product page and choose your target database.

Target Databases
  • Oracle
  • Sybase
  • SQL Server
  • Informix
  • IBM DB2
  • Netezza
  • MySQL
  • MariaDB
  • Amazon Aurora
  • Teradata
  • HP Neoview
  • PostgreSQL
  • Amazon Redshift
  • HP NonStop SQL/MX
     Version details
September 1, 2014Continental Tire the Americas, LLC, United States
DB2 to Oracle Migration

"Recently it became necessary to migrate our existing DB2 database into an Oracle environment. Our migration required that all tables, data, triggers and functions...


October 9, 2013Ventyx, Australia
DB2 LUW to Oracle on Linux Migration

"To whom it may concern,
My name is Bill Lloyd and I work as a Senior DBA for Ventyx, a leading software company supplying software products primarily to the...


Case Studies
January 5, 2018IBM DB2 LUW to PostgreSQL Migration, United States

Our Customer was the US public corporation and independent unit of state government.


September 11, 2017Sybase ASE to Microsoft SQL Server, Chile

Ispirer has already completed projects for customers from all seven continents, including South America. This time we had the honour to cooperate with a large software manufacturer based in Chile.



Our team was very impressed with your migration tool. We successfully imported two tables into a SQL database. The tool was simple to use and the results were 100% accurate. We want to migrate the Informix database into SQL for long-term archival. This migration will take place after we implement our new software solution. Looking forward to working with your company in the very near future.

Read more
Industry Events