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.
Note: Apart from this project, our team has performed another 17 other database migrations.
Technologies: DB2, Oracle, MTK, Informix