The Story About The Migration

" summary

A Microsoft team migrated a complex Oracle schema to PostgreSQL using ora2pg and re‑architected application code to match Oracle Exadata performance on Postgres Single Server. The talk covers practical problems and solutions for migrating BULK COLLECTs, hierarchical CONNECT BY queries, refcursors, dynamic queries and other Oracle constructs, why ora2pg’s estimates were inaccurate, and the team’s working approach and testing/debugging experiences.

AI-written summary · about

" related talks

• 29mTales from the Field - Oracle to PostgreSQL migrationsAdithya Kumaranchath · POSETTE: An Event for Postgres 2024
• 06mMigration Consideration Oracle to PostgreSQLNeeta Goel · PGConf India 2025
• 46mThe Top 10 Mistakes When Migrating Oracle Databases to PostgreSQLJim Mlodgenski · Percona Live 2022
• 01h 09mReplacing Oracle Features in PostgreSQL: HA, Functions & ExtensibilityShayon Sanyal · Postgres Conference Orlando 2025
• 48mMigrating to PostgreSQL: Strategies, Sovereignty, and SuccessRaphael Salguero · PostgreSQL Conference Europe 2025
• 31mSimplifying the Top Complexities While Migrating From Oracle to PostgreSQLAvinash Vallarapu · Percona Live 2022
• 24mMigrating from Oracle to Azure Database for PostgreSQL, SeamlesslyNeeta Goel, Sandeep Rajeev · POSETTE: An Event for Postgres 2025
• 30mAn Assessment-to-Adoption Path from Oracle, SQL Server, Sybase, DB2 ontoAvi Vallarappu · Distributed SQL Summit Mumbai 2026