Migration Consideration Oracle to PostgreSQL

on YouTube ↗06m

" summary

Claims that successful Oracle→PostgreSQL migration requires upfront discovery of unsupported Oracle features, explicit handling of schema complexity and automated type-casting, and careful rewrites for stored procedures, functions and embedded dynamic SQL. Gives concrete demands: handle timestamp/date differences, variable conversions (trunk→date_trunk), and impacts on application code, citing a case with >10 million lines and >10,000 queries. Recommends a cloud migration cockpit and a full automation framework to speed conversion and enable go-live.

AI-written summary · about

" related talks

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