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.

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.

 
view a demo
request a demo
request sqlways
request a quote
Solutions
SQLWays for IBM DB2
IBM DB2 Databases

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

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

IBM DB2 for iSeries and AS/400 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
  • Teradata
  • MySQL
  • HP Neoview
  • PostgreSQL
  • HP NonStop SQL/MX
     Version details