This is a software tool and migration process from Oracle to DB2 OS/390 database.
Highly automated and software driven processes are used to get the Oracle data migrated to DB2 OS/390 database setup. The software SQLWays offers an automatic migration process. Most of the process is carried out by the software tool. To further validate the process the agency uses a set of accumulated test cases. These are some 40,000 case they have accumulated over the years from the migrations they have carried out between different databases. Legacy system emulation is not tried. By following the recommended best practices of the target platform standalone SQL statements, functions, scripts and various code fragments are converted easily. The migration process covers complete range of DDL to server-side business logic and front-end application conversion. Technical members participate in any tweaks and adjustments that need to be done and to carry out the validations mentioned.
API in various applications: Java, COBOL, PowerBuilder, C++, C#/VB.NET, ESQL, ASP, ASP.NET, etc. and embedded SQL statements and database are migrated without errors. Conversions between ESQL, ODBC, Oracle OCI, Oracle Pro*C, Sybase CT/LIB, and other interfaces are carried out. Potential clients can order an evaluation phase. During this phase a limited set of data is converted following the same process. Clients then can verify results meet their expectations. The production phase takes care of database schema/DDL, server side business logic procedures and triggers, front end applications and scripts, application conversion, etc. This is a very good product and worth a try, if you have a need.