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.

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