Accelerating Database Migration to Azure PaaS PostgreSQL: A Fortune 500 Insurance Company Success Story

Executive Summary:

This white paper presents a successful migration project for a Fortune 500 insurance company that needed to migrate two of their critical databases from Oracle to Azure PaaS PostgreSQL within 3 months. The company was facing a time crunch with Oracle license renewal due and needed to migrate the databases to PostgreSQL to avoid additional costs. The databases were complex and business-critical, with 3TB of data, 70% of which was BLOB storage. Additionally, 30,000 lines of PLSQL code for business logic were embedded in the database.

Challenge:

The company needed to migrate two of their critical databases to Azure PaaS PostgreSQL within 3 months to avoid additional costs from Oracle license renewal. The databases were complex and business-critical, with 3TB of data and 70% of which was BLOB storage. Additionally, 30,000 lines of PLSQL code for business logic were embedded in the database. The company needed automation and an experienced partner to ensure timely migration.

Solution:

Newt Global used DMAP, its database migration assessment and planning tool, to assess the current database environment and provide a proposal quickly. With 82% automation using DMAP in schema conversion, Newt Global’s team delivered the converted and tested schema with migrated data in Azure PostgreSQL for QA within 4 weeks. Newt Global collaborated to support User Acceptance Testing (UAT), prepare production cutover plans, and supported the Go-Live from the customer location in Singapore.

Business Impact:

The migration was completed as planned, despite delays in access and an increase in scope. The new database size changed from 700 GB to 3 TB. Data migration during cutover windows was accomplished in 2 hours with at-scale concurrent processes using DMAP. Schema and data validation post migration was completed in 2 hours. Zero post-production issues with schema or data were reported. The project was formally closed, including warranty, as planned. Approximately $500K USD savings are expected over 5 years by exiting Oracle, reducing the current cost by 50%.

Conclusion:

This white paper presents a successful migration project for a Fortune 500 insurance company that needed to migrate two of their critical databases to Azure PaaS PostgreSQL within 3 months. The migration was accomplished using DMAP, Newt Global’s database migration assessment and planning tool, which automated the schema conversion process and enabled the team to deliver the converted and tested schema with migrated data in Azure PostgreSQL for QA within 4 weeks. The migration was completed on time, and the company was able to avoid additional costs from Oracle license renewal. The company also achieved significant cost savings by exiting Oracle and reducing current costs by 50%.