Migrating VLDBs from Oracle to Azure Database for PostgreSQL

on YouTube ↗25m

" summary

Migration strategy for multi‑terabyte Oracle workloads shows a successful 16 TB case that uses a phased approach: Ora2Pg for schema conversion, parallel partitioned loads via Azure Data Factory, and continuous sync with Striim to achieve a near‑zero‑downtime cutover (minutes of downtime). Guidance covers sizing WAL throughput/IOPS from Oracle AWR, handling LOBs by offloading to Azure Storage, avoiding bloat/autovacuum stalls, and spending months and multiple tuning cycles (4–5) to reach predictable performance.

AI-written summary · about

" chapters (9)

1. 0:00Music & introduction
2. 1:04The problem of large database migration
3. 2:02Why customers choose PostgreSQL
4. 3:54Key challenges in VLDB migration
5. 9:00Customer case study: oracle to PostgreSQL
6. 15:40VLDB migration lifecycle, process, & tool recommendations
7. 19:02Advanced considerations: complexity, scale, & time
8. 21:46Common pitfalls and optimization strategies
9. 24:20Closing remarks and resources

" related talks

• 24mPartitioning strategy for Oracle to PostgreSQL migrations on AzureAdithya Kumaranchath · Citus Con: An Event for Postgres 2023
• 29mTales from the Field - Oracle to PostgreSQL migrationsAdithya Kumaranchath · POSETTE: An Event for Postgres 2024
• 24mMigrating from Oracle to Azure Database for PostgreSQL, SeamlesslyNeeta Goel, Sandeep Rajeev · POSETTE: An Event for Postgres 2025
• 49mIt keeps getting easier to move Oracle and Open Source workloads to AzureDavid Levy · SQLBits 2023
• 56mMigrate Databases to the Cloud - Why, How and Best PracticesAmit Bansal · Great Indian Developer Summit 2015
• 56mSeamless Migration to Azure Database for PostgreSQLJean Joseph · Postgres Conference Orlando 2025
• 30mAn Assessment-to-Adoption Path from Oracle, SQL Server, Sybase, DB2 ontoAvi Vallarappu · Distributed SQL Summit Mumbai 2026
• 42mMigrating a database over 10TB from DB2 to PostgreSQL with zero downtimeDmitriy Pogibenko · РИТ++ 2017