Migrating iSeries AS/400 Databases


SQLWays converts database schema (DDL) and data from IBM DB2 iSeries and OS/400 (AS/400) 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 AS/400 support including file members
  • 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
    • Converts integrity constraints - primary and foreign keys, unique and check constraints
    • Converts comments
    • Supports File members
    • Transfers data
  • Indexes and Views

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

IBM DB2 for iSeries and AS/400 V5R4, V5R3, V5R2, V5R1, V4R5, V4R4

Target Databases
  • Oracle
  • Sybase
  • SQL Server
  • Informix
  • IBM DB2
  • Netezza
  • Teradata
  • MySQL
  • HP Neoview
  • PostgreSQL
  • HP NonStop SQL/MX
     Version details