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.

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
May 17, 2018Schulz, Brazil

InterBase to Microsoft SQL Server
Database Migration

In order to change a factory supervision and information system, we were looking for a tool to migrate the existing "Interbase...

...

May 15, 2018System Protocol Information, Malaysia

Informix to Microsoft SQL Server
Database Migration

Dear Sir / Madam,

We have just completed our biggest migration job to date from Informix to MS SQL Server. The exercise was...

...

Feedback

We have been researching a number of products that will improve the way that we are exporting data from Progress into SQL server. I have been testing your product as part of a test run for a new job that we have won. My initial thoughts are very positive because it is saving us time plus we can set the export running without having to worry about the export.

Read more
Company News
Industry Events