This is a migration tool for MySQL to DB2 Express.
Highly automated and software driven processes are used to get the MySQL data migrated to DB2 Express database setup. The software SQLWays, used by the agency, supports automatic processes for migration. 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. Technical members in the agency participate as and when needed to complete the migration process. A set of some 40,000 test cases are used to validate the converted data. The validation is conducted by these technical members. These are the situations the agency has accumulated over the years from the migrations they have carried out between different databases. Complete range of DDL to server-side business logic and front-end application conversion are carried out.
Conversions between ESQL, ODBC, Oracle OCI, Oracle Pro*C, Sybase CT/LIB, and other interfaces are carried out. 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. You can use an evaluation phase to satisfy yourself with the processes. A limited set of data is converted following the same process in this phase. 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. Try it out if you have a need.