Database Migration

Customer: A major database migration solution developer.

Task: Database migration from Oracle and Informix to IBM DB2, including the structure, the data and the business logic (including stored procedures, functions and triggers).

The project was implemented in three stages:

  • First stage, the 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.