Case Study: Oracle to Aurora PostgreSQL Migration
Details
Join us for a technical case study detailing how Mydbops migrated a core 4TB Oracle RAC database to AWS Aurora PostgreSQL 15 for a leading health insurer in India.
In this session, our Founding Partner, Kabilesh PR, will share the practical engineering playbook, real-world challenges, and solutions from this migration.
What we will cover:
• Schema Mapping: How we handled Oracle data types like NUMBER, DATE, and CLOB/BLOB.
• Code Conversion: Practical patterns for rewriting PL/SQL packages, functions, and outer joins (+) to PL/pgSQL.
• Data Pipeline: Setting up AWS DMS for initial bulk loading and continuous replication (Change Data Capture).
• The Cutover Strategy: Our 8-phase plan to execute the final cutover within a 30-to-45-minute window.
About the Speaker:
Kabilesh PR is a Founding Partner at Mydbops with over 13 years of database experience, specializing in open-source databases, DistributedSQL, and complex migrations.
How to Join:
This is an online webinar. To receive the live access link, please register via our website:
https://www.mydbops.com/webinars/oracle-to-postgresql-health-insurance-case-study