Oracle to DB2 z/OS Express Ispirer SQLWays 6.0 Migration Tool

This is a software tool and migration process from Oracle to DB2 z/OS database.

The service agency uses highly automated software SQLWays. This makes a highly automated process that enables migration of Oracle database to DB2 z/OS database setup. The software solution ensures consistent and correct results. To ensure further consistency and correctness of the migration process, the service agency uses a large number of test cases they have accumulated over the years. A bank of 40,000 odd test cases has been collected through migration work done over all kinds of databases. Full range of DDL to server-side business logic and front-end application conversion is carried out. Technical people of the agency take part in the process. An evaluation phase is offered. A small set of data is converted for clients to evaluate the results. Database schema/DDL, server side business logic procedures and triggers, front end applications and scripts, application conversion, etc. are taken care of to ensure completeness of the process.

The SQLWays conducts comprehensive assessment and migration of embedded SQL statements and database API in various applications: Java, COBOL, PowerBuilder, C++, C#/VB.NET, ESQL, ASP, ASP.NET, etc. Conversions between ESQL, ODBC, Oracle OCI, Oracle Pro*C, Sybase CT/LIB, and other interfaces are carried out. Standalone SQL statements, functions, scripts and various code fragments are converted easily. The company follows the recommended best practices of the target platform. They do not attempt legacy system emulation at all. This process generates readable and maintainable code. This is a very good product.

The full version of SQLWays Database and Application Migration Tool can control the entire migration cycle providing high automation of all migration phases.
SQLWays converts stored procedures, functions, triggers, database schema (DDL), data, views, etc. The tool is especially useful when you need to transfer large data volumes over a short or limited period of time. SQLWays is a very flexible tool, which can be easily customized for any migraiton project. The tool is used for:
Database Migration
SQLWays migrates an entire database including data, database schema, business logic and scripts between major database management systems. The tool supports the largest number of databases including all the leading and most legacy databases - from the latest to very old versions - and the list of supported databases and their versions is constantly growing. Supported source and target databases include Oracle, DB2 z/OS, Progress, Interbase, HP NonStop and others.
Embedded SQL/Database API Conversion
SQLWays automatically performs comprehensive assessment and migration of embedded SQL statements and database API in various applications: Java, COBOL, PowerBuilder, C++, C#/VB.NET, ESQL, ASP, ASP.NET etc. It supports conversions between ESQL, ODBC, Oracle OCI, Oracle Pro*C, Sybase CT/LIB, and other interfaces. It allows to dramatically decrease conversion risks and reduce time spent on the project.
Application Conversion
SQLWays can automatically convert applications between various platforms and programming languages. The list of source programming languages and platforms includes Progress 4GL, Informix 4GL, COBOL, PL/SQL, Oracle Forms, Delphi, Powerbuilder and others. The most popular target technologies supported by the tool are Java and C#.NET. SQLWays can also convert such parts of application as business logic, user interface and reports. The level of conversion automation can reach up to 95%.