Migrating to PostgreSQL: Strategies, Sovereignty, and Success
summary
Argues migrations to PostgreSQL are practical but require a disciplined assessment, change management and a phased plan: run a scoped DDL audit to score incompatibilities, start with low-hanging fruits (tables/indexes) then convert logic, and expect work on packages, global temporary tables, XML/LOBs and SQL dialect differences. Recommends tools and patterns like ora2pg, paid converters or scripts, CSV/Python loads or CDC via Debezium/Kafka, and LOB handling with pg_largeobject and application-side shifts where needed.
AI-written summary · about
chapters (9)
- 0:00Introduction to migration
- 3:12Why migrate to PostgreSQL
- 7:21Migration framework and change management
- 13:42Discovery and design phases
- 21:45Assessment and complexity
- 25:59Common migration issues
- 35:12Data migration strategies
- 38:22Integration and operation
- 40:08Q&A session
related talks
46mThe Top 10 Mistakes When Migrating Oracle Databases to PostgreSQL
06mMigration Consideration Oracle to PostgreSQL
45mSQL Server to PostgreSQL: Migration Challenges & Solutions
29mTales from the Field - Oracle to PostgreSQL migrations
34mPartitioning and Data Migrations Using PostgreSQL as an Example
34mPartitioning and Data Migrations Using PostgreSQL as an Example
26mMastering Large-Scale PostgreSQL Migration
27mMigrating from MSSQL to PostgreSQL