Tales from the Field - Oracle to PostgreSQL migrations
summary
Enterprise migrations from Oracle to Postgres use concrete tactics: a trading app handling 1 million messages per minute migrates with phased pipelines and a migration factory, and a 2 TB Oracle table becomes 10 TB after migration until data type and column-order fixes restore size. Tools used include pgBadger for query analysis, Ora2Pg and an API layer for automated schema moves; Azure Database for PostgreSQL Flexible Server plus Azure Data Factory and CDC tools (HVR/Striim) provide near-zero-downtime sync, backups and faster ops, and tuned queries achieve equal or better performance and big license savings.
AI-written summary · about
chapters (7)
- 0:00Intro
- 1:09Reasons to migrate from Oracle to PostgreSQL
- 3:16Migration challenges
- 8:211st Customer Story: Bank in Southeast Asia
- 13:322nd Customer Story: Media company in Europe
- 18:26Why Azure Database for PostgreSQL?
- 23:05Migration tips & tricks
related talks
06mMigration Consideration Oracle to PostgreSQL
24mMigrating from Oracle to Azure Database for PostgreSQL, Seamlessly
37mDatabase Modernization at Cloud Scale: Minimizing Risk and Disruption
46mThe Top 10 Mistakes When Migrating Oracle Databases to PostgreSQL
48mMigrating to PostgreSQL: Strategies, Sovereignty, and Success
30mAn Assessment-to-Adoption Path from Oracle, SQL Server, Sybase, DB2 onto
51mOracle to PostgreSQL Migration with Near Zero Downtime
25mMigrating VLDBs from Oracle to Azure Database for PostgreSQL