An Assessment-to-Adoption Path from Oracle, SQL Server, Sybase, DB2 onto
summary
A migration framework shows an automated pipeline: an assessment scans code and objects, ExaScaler runs schema conversion, data migration, live replication and rollback, and Ora2Pg + Voyager provide compatibility and sizing. A case study assesses 120 Oracle databases in 28 minutes and finds 70% require minimal modernization. A hybrid approach pairs tuned LLMs with an AST-based deterministic transpiler to convert PL/SQL to Postgres/Yugabyte, handle terabyte-scale parallel data loads, and surface residual manual work and remediation counts.
AI-written summary · about
chapters (13)
- 0:00Database modernization challenges
- 2:13Assessment-led modernization
- 6:52Migration vs modernization
- 9:02Why assessment first
- 10:06Database assessment tools & case study
- 13:57Ora2Pg migration insights
- 16:27ExaScaler migration platform
- 17:11AI challenges in code conversion
- 18:57AST transpiler for code conversion
- 22:05Yugabyte integration demo setup
- 23:08Schema migration to Yugabyte
- 26:21Data migration transformations
- 29:12Yugabyte POC success
related talks
29mTales from the Field - Oracle to PostgreSQL migrations
06mMigration Consideration Oracle to PostgreSQL
37mDatabase Modernization at Cloud Scale: Minimizing Risk and Disruption
24mMigrating from Oracle to Azure Database for PostgreSQL, Seamlessly
48mMigrating to PostgreSQL: Strategies, Sovereignty, and Success
27mOSSom for Better Oracle to Postgres Assessments
49mIt keeps getting easier to move Oracle and Open Source workloads to Azure
43mPostgresQL as an Application Modernization