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.

 
online presentation
live presentation
download sqlways free express version
download a demo
purchase license
Solutions
SQLWays for IBM DB2
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
  • SAP HANA
  • HP Neoview
  • PostgreSQL
  • HP NonStop SQL/MX
     Version details
Testimonials
February 6, 2014Retalon, Canada
MS SQL Server to DB2 Migration

"I was looking for the way to convert tables from MS SQL Server to my DB2 Server running in Linux. I chose Ispirer Systems Migration Tool. The SQLWays migration...

...

October 1, 2013Andsome&Company, Korea
DB2 AS400 to Oracle Migration

"Andsome&Company Co., Ltd. have used SQLWays for 2 months in process of converting existing DB2 in AS400 to Oracle 11g release 2 both data and sources. ...

Case Studies
August 19, 2014DB2 z/OS to Oracle Migration, United States

Our client was a Group of Companies from the United Stated providing Steel Mill, Aggregate and Asphalt products for more than 90 years.

...

August 19, 2014PowerBuilder to C# Conversion, Canada

Our client was a leader and innovator in integrated pharmacy technology from Canada. He addressed to Ispirer in order to perform an application migration.

...

News
Events