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