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
February 5, 2018Gisoft Ltd. Russia
Microsoft SQL Server to PostgreSQL migration

"Gisoft Ltd., the software developer of automated control systems for education, after numerous and mostly unsuccessful experiments and efforts to...

...

January 18, 2018SEA PRODUCTIQUE, France
InterBase 6.0 to Microsoft SQL Server

Within the framework of the factory's supervisory and information system updating project we were looking for a tool to migrate the existing "Interbase...

...

Feedback

I did review the price quotes and have shared them with the project team. I think they are quite reasonable and will see if I can influence the decision makers.

Read more
Company News
January 31, 2018PGConf.Russia 2018
November 23, 2017Happy Thanksgiving Day!
Industry Events