Intelligent, Custom and Highly Automated Cross Platform Database and Application Migration

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
April 12, 2018Ocure Analytics, Hungary
Microsoft SQL Server to PostgreSQL Migration


To whom it may concern

Ocure Analytics has selected and engaged Ispirer Systems to transform one of our MS SQL databases to Postgresql...

...

March 30, 2018Kazakh National Pedagogical University
PASCAL to C#.NET Migration

I am doing academic work at Kazakh National Pedagogical University.

During the process of electronic textbooks implementation, we faced conversion task that...

...

Feedback

We tried the Trial version and tried to convert one of the Stored procedure. The result was better that the other products which we tried.

Read more
Company News
Industry Events