Migration validation made easy with Ora2Pg

on YouTube ↗54m

" summary

Ora2Pg celebrates 20 years and now includes concrete validation: a test action that compares schema and row counts, and a data validation mode that pulls rows via an Oracle FDW and compares values (default 10k rows per table, stops after 10 errors). It emits DDL, parallel-loads data (author claims ~100 GB/hour pre‑FDW and much faster with FDW + many processes), handles many type mappings and BLOBs, but has limits: per‑schema tests, needs PKs, partial PL/SQL translation, and no full application/view validation.

AI-written summary · about

" chapters (14)

1. 0:00Intro
2. 2:24Celebration
3. 5:01Steps of a migration
4. 8:40Testing
5. 10:34Type of objects
6. 14:03Validation of data type
7. 22:40Checking the number of lines
8. 27:00Data migration time
9. 32:41Data validation
10. 34:49Prerequisites
11. 37:57Settings
12. 44:10Example of definition change
13. 45:39How about data type differences
14. 46:59Test of procedures

" related talks

• 27mOSSom for Better Oracle to Postgres AssessmentsAlicja Kucharczyk, Diaa Radwan · Citus Con: An Event for Postgres 2022
• 30mAn Assessment-to-Adoption Path from Oracle, SQL Server, Sybase, DB2 ontoAvi Vallarappu · Distributed SQL Summit Mumbai 2026
• 29mTales from the Field - Oracle to PostgreSQL migrationsAdithya Kumaranchath · POSETTE: An Event for Postgres 2024
• 01h 09mReplacing Oracle Features in PostgreSQL: HA, Functions & ExtensibilityShayon Sanyal · Postgres Conference Orlando 2025
• 06mMigration Consideration Oracle to PostgreSQLNeeta Goel · PGConf India 2025
• 46mThe Top 10 Mistakes When Migrating Oracle Databases to PostgreSQLJim Mlodgenski · Percona Live 2022
• 51mOracle to PostgreSQL Migration with Near Zero DowntimeSumit Aneja, Vinay Kamble · Percona Live 2022
• 48mMigrating to PostgreSQL: Strategies, Sovereignty, and SuccessRaphael Salguero · PostgreSQL Conference Europe 2025