- Customer: Payment automation solution provider
- Country: United States
- Product Used: Ispirer Migration Service
- Source Technology: Db2 LUW
- Target Technology: PostgreSQL
- Project Scope: 50,000 LOC
- Project Duration: 5 months
Ispirer Migration Service
Replacing IBM Db2 with an open source PostgreSQL database as the primary storage solution across the platform enabled the innovator in business payment automation technologies to save on licensing, support, and maintenance costs.
Our customer is a trusted SaaS provider with an in-depth expertise in domestic and international payment solutions. The company enables banks and businesses to simplify and manage their operations and end-user solutions securely, so they can focus on what matters most – the growth of their business. The organization helps thousands of companies of all sizes across all industries in 92 countries around the world.
The customer owns a platform consisting of multiple applications that interact with shared data stores to allow client insurance company users and law firm users to work together processing legal bills.
The goal of this project was to replace IBM Db2 LUW 9.1 as the primary storage solution across the platform. The customer chose to move to PostgreSQL 12.12 on Linux to save on licensing, support, as well as maintenance costs. Platform functionality was not expected to change due to the migration.
In order to implement this digital transformation project, the customer turned to an IT service and consulting company. Their team, reinforced with Ispirer experts and Ispirer migration automation solutions, carried out the transfer of the Db2 database to PostgreSQL.
Having reviewed the offers of migration service providers, the consulting company decided Ispirer Migration Service was the most suitable solution for handling the end-customer’s database system migration. Ispirer Systems was chosen because of our proven track record of delivering comprehensive database migration services, as well as our proprietary toolkit that markedly reduces the time and cost of the migration project.
The Ispirer team was responsible for converting the SQL scripts. The task was to deliver the scripts with the converted code of the approved object scope within the set deadlines. Deployment and data migration were out of the project scope.
Based on the analysis, the Ispirer team compiled a report listing the bugs, their complexity, suggested ways and required time to eliminate them.
At the conversion stage, the customer had several requirements that differ from the standard migration patterns. For example, converting CURRENT TIMESTAMP to CLOCK_TIMESTAMP, and then to CURRENT_TIMESTAMP.
Nonetheless, all the above issues and requirements were successfully resolved. The Ispirer team converted the scripts and uploaded them from VDI to the version control system. Once approved by the end-customer reviewers, the scripts were uploaded to the main project repository. All SQL code was converted and delivered to the end-customer ahead of schedule.
With the help of Ispirer's experts, the database migration from Db2 LUW to PostgreSQL was completed in 5 months. The project scope included 50,000 lines of converted Db2 LUW code.
The robustness, world-class performance, extensibility, and support for a variety of data types and index methods of an open source alternative like PostgreSQL make it a popular choice among enterprise owners.