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.