Customer: large company developing database migration solutions.
Task: Migrate a database from Oracle and Informix to IBM DB2, including the structure, the data itself and, most importantly, the business logic (stored procedures, functions and triggers).
The project was implemented stage by stage:
First stage, the RELEX team carried out the complete analysis of source code
Second stage included database structure migration and automatic migration of stored procedures using DB2 Migration Toolkit (MTK).
Third stage included manual correction of automatic migration errors, and migration of the most complicated code parts that could not be converted by MTK.
The team created unit tests, tested and debugged the code. The final stage was to optimize the code of the stored procedures.
Note: Apart from this project, our team has performed another 17 other database migrations.
Technologies: DB2, Oracle, MTK, Informix