This is a software tool and migration process from Oracle to DB2 Express database.
Highly automated and software driven processes are used by the service provider to get the Oracle database to DB2 Express database setup. The software SQLWays is a software solution automates most of the process and that can ensure consistent and correct results. The service bureau has a collection of large number of test cases that are used to verify the outcome of the migration process. They have something like 40,000 cases that can ensure consistent results of the conversion. Members of the organization assist in the conversion of the full range of DDL to server-side business logic and front-end application conversion. The service agency offers an evaluation phase when clients can get a small set of data converted to get a feel of the conversion. The production phase of the process takes care of database schema/DDL, server side business logic procedures and triggers, front end applications and scripts, application conversion, etc.
The company follows the recommended best practices of the target platform. Legacy system emulation is not tried. Standalone SQL statements, functions, scripts and various code fragments are converted easily. 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. This process generates readable and maintainable code. This is a very good product.