Migrating IBM DB2 z/OS S/390 Mainframe

SQLWays 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 SQLWays can migrate Oracle to DB2 OS/390 database:

Why SQLWays

  • 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, SQLWays also converts SQL queries in front-end applications and scripts.

SQLWays 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 SQLWays product page and choose your target database.

IBM DB2 Databases

IBM DB2 for Linux, Unix and Windows 10.х, 9.x, 8.x, 7.x, 6.1 and 5.2

IBM DB2 for z/OS and OS/390, MVS 10.х, 9.x, 8.x, 7.x, 6.x, 5.x, and 4.1

IBM DB2 for iSeries and AS/400 7.1, 6.1.x, V5R4, V5R3, V5R2, V5R1, V4R5, V4R4

IBM DB2 for z/OS and OS/390, MVS 9.x, 8.x, 7.x, 6.x, 5.x, and 4.1

Target Databases
  • Oracle
  • Sybase
  • SQL Server
  • Informix
  • IBM DB2
  • Netezza
  • MySQL
  • Teradata
  • HP Neoview
  • PostgreSQL
  • 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
November 24, 2015DB2 to Oracle and COBOL to PL/SQL Migration, United States

It was real estate financial and IT services provider. The company specializes in introducing high technology solutions into their customers’ businesses in property sector. The firm renders a...


November 16, 2015Sybase ASE to DB2, South Africa

It was a company providing IT and communication services founded more than 20 years ago. Our client assists in database and mobile platform management, introducing technology innovations in its...



The application is running since 15 days without any crashed, I did few minor corrections but the system is very stable and the respond time is correct.
Read more
Industry Events