Our customer was the US public corporation and independent unit of state government.
The customer approached Ispirer Systems with the challenge of implementation of PostgreSQL as the enterprise database platform. To achieve this aim they needed to transfer over 300 tables and 5 terabytes of data in multiple QA and production environments from IBM DB2 LUW to PostgreSQL.
Ispirer Migration and Modernization Toolkit has been chosen for automated data migration. The Ispirer support team was diligent and responsive in supporting the client through the year long process helping them make updates to the tool to meet special customized situations in the migration and also for fixing the issues that were identified in the migration process.
For example, the solution that emulates MONTHS_BETWEEN function in PostgreSQL has been developed specifically for this project.
Besides, support of TABLESPACE conversion in tables and support of Common Table Expressions in views has been added.
The customized Ispirer MnMTK Toolkit seamlessly handled the conversion of structures and data types of over 300 tables from DB2 to PostgreSQL semantics.
Results & Advantages
The whole migration project was successfully accomplished in due time. Both data and table conversion processes went smoothly. The tool helped the client to migrate over 5 terabytes of total data from IBM DB2 to new PostgreSQL database in a timely, automated, and repeatable fashion.
The client remained satisfied with the product choice and the results obtained. Its Chief Information Security Officer said: “Overall, we are very happy with the product's capabilities and will recommend this to any enterprise undertaking large scale database migration efforts.”