THIS SITE USES COOKIES: By continuing to browse this site, you give your consent for cookies to be used.
For more details, please read our Privacy Policy and Cookies Policy.

Automated and Customizable
Database and Application
Migration and Modernization

IBM DB2 LUW to PostgreSQL Migration, United States

Customer

Our Customer was the US public corporation and independent unit of state government.

Challenge

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.

Solution

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.”

2017



Learn more about IBM DB2 LUW to PostgreSQL Migration

 
Testimonials
July 23, 2018Decitre, France

Decitre, France


'The Ispirer team turned out to be very responsive, our customization requests were...
...

July 20, 2018Verint, United Kingdom

Verint, United Kingdom


'Ispirer were a joy to work with and were always quick to respond to any...
...

Feedback

We’re successfully tested the tool and we’re interested in buying the licence.

Read more
Company News
Industry Events