OSSom for Better Oracle to Postgres Assessments
summary
A tool called OSSom (OSS Open Migrator) wraps ora2pg in a containerized Flask UI that runs ora2pg, applies the converted DDL to Postgres and reports counts and percentages of successes and errors. It outputs how many objects migrate automatically, how many require manual intervention and an estimated effort; demo of the HR schema shows 100% object success. Delivered as Docker Compose/Kubernetes manifests under MIT, roadmap adds schema compare, data validation, online migration and performance fixes.
AI-written summary · about
chapters (7)
- 0:00Introduction
- 1:44Inspiration for the OSSom Open Migrator
- 3:44What is ora2pg?
- 5:44The challenge with ora2pg?
- 10:36OSSom architecture
- 13:30Demo of OSSom
- 20:30Q&A with Alicja, Diaa, & Claire
related talks
30mAn Assessment-to-Adoption Path from Oracle, SQL Server, Sybase, DB2 onto
29mTales from the Field - Oracle to PostgreSQL migrations
54mMigration validation made easy with Ora2Pg
06mMigration Consideration Oracle to PostgreSQL
01h 09mReplacing Oracle Features in PostgreSQL: HA, Functions & Extensibility
48mMigrating to PostgreSQL: Strategies, Sovereignty, and Success
51mOracle to PostgreSQL Migration with Near Zero Downtime
46mThe Top 10 Mistakes When Migrating Oracle Databases to PostgreSQL