Migrating from Oracle to Azure Database for PostgreSQL, Seamlessly
summary
Claims a 4x speedup—moving projects from 12 months to 12 weeks—by combining an AI engine called DMAP with a process wrapper, the CMC Framework. Shows automation handling schema conversion (examples: coalesce for NULL math, nullif for empty strings, date_trunc/INTERVAL and to_timestamp fixes), data migration, and app remediation (sysdate → statement_timestamp, sqlplus → psql). Demonstrates scale: a 200,000‑line PL/SQL schema, ~700 packaged globals, and ~1,600 execute statements that require automated detection and remediation to avoid runtime failures.
AI-written summary · about
chapters (9)
- 0:00Introduction
- 1:39Migration considerations
- 2:11Schema Conversion
- 7:24Dynamic SQL
- 8:21Handling Data Type Change
- 12:16DB Server & Performance
- 13:11Data Migration
- 20:18Oracle to Postgres Auto Conversion
- 21:38DMAP Led DB & Application Migration
related talks
29mTales from the Field - Oracle to PostgreSQL migrations
06mMigration Consideration Oracle to PostgreSQL
49mIt keeps getting easier to move Oracle and Open Source workloads to Azure
25mMigrating VLDBs from Oracle to Azure Database for PostgreSQL
30mAn Assessment-to-Adoption Path from Oracle, SQL Server, Sybase, DB2 onto
56mSeamless Migration to Azure Database for PostgreSQL
44mAccelerate your Oracle & Mainframe Modernization journey to Azure SQL
24mPartitioning strategy for Oracle to PostgreSQL migrations on Azure