bizacuity
Contact Us

IBM DB2 to Postgres Migration

About Client

One of Asia’s largest E-commerce marketplaces that assists businesses with services in the areas of e-auction and e-procurementt of resources like steel, oil and coal.
Revenue: $185 million

Challenge

The client was using IBM DB2 database and wanted to migrate to PostgreSQL due to 2 main reasons:

  • PostgreSQL is an object-oriented database (ORDBMS) whereas DB2 is only relational (RDBMS)
  • PostgreSQL is a highly secure, open source tool while DB2 requires a commercial license

Due to lack of in-house IT expertise, the client was not in the position to manage data inconsistency across multiple platforms and was unable to kick-off the migration process

Our Solution

The BizAcuity team helped in the data migration by executing the following steps:

  • Conversion of Procedures using AWS SCT
  • Conversion of procedures manually (those that couldn’t be converted using AWS SCT)
  • Updated procedures after conversion as per requirements.
  • Fixed the code, queries and procedure calls in the code base via navigation of the application
  • Fixed the code, queries and procedure calls directly in the Action Classes, Service Layers and Implementation Layers

Outcome

  • Successfully migrated from DB2 to Postgres
  • Updated existing SQL commands as per Postgres norms

Recent Case Studies

Talk to Our Experts

Leave a Reply

Your email address will not be published. Required fields are marked *

Quick Links
Our Locations
Gartner Reviews
Subscribe to Newsletter

© 2025 BizAcuity Solutions Pvt. Ltd. All Rights Reserved *

BizAcuity
Powered by  GDPR Cookie Compliance
Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.