Client: a leading worldwide provider of payment technology services.
Task: It was required of us to migrate a database from Oracle 11g to DB2 10.5. We migrated four Oracle databases to a single one on DB2. The requirements included migration of data loading scripts and modification of a custom framework with facilities of both database creation from scratch and performing incremental updates.
We migrated DDLs, stored procedures/packages, data loading scripts, and developed several modules in Java/C whose purpose is to provide missing/insufficient DB2 functionality. We also migrated a set of Perl scripts (main script size ~11K lines).
Technologies: Java, Perl, C, Oracle, DB2
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