2148141
page-template,page-template-right_sidebar,page-template-right_sidebar-php,page,page-id-2148141,page-child,parent-pageid-12536,strata-core-1.0.5,ajax_fade,page_not_loaded,wpb-js-composer js-comp-ver-6.2.0,vc_responsive

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

However, due to data inconsistency issues across multiple data platforms and lack of in-house IT expertise, the client 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

Would You Like Us To Contact You?

  • This field is for validation purposes and should be left unchanged.