All the Secrets to Migrate from ELCARO to PostgreSQL

on YouTube ↗45m

" summary

Practical guide to migrating from the proprietary ELCARO database to PostgreSQL, covering when migration is feasible, how to handle PL/SQL code, converting and optimizing DDL, common pitfalls, choices between offline and real‑time migration, performance tuning, and options for moving to cloud providers like AWS or GCP.

AI-written summary · about

" chapters (12)

1. 0:00Introduction
2. 3:30Reasons to migrate
3. 7:23BlackBerry case study
4. 11:58SQL and schema migration
5. 17:24Data types and permissions
6. 20:33Data cleanup and indexes
7. 23:40Stored procedures and PL/pgSQL
8. 26:54Google Cloud architecture
9. 30:03Zero-downtime migration with CDC
10. 36:21GoldenGate setup
11. 40:36Testing and rollback
12. 42:01Conclusion

" related talks

• 48mMigrating to PostgreSQL: Strategies, Sovereignty, and SuccessRaphael Salguero · PostgreSQL Conference Europe 2025
• 06mMigration Consideration Oracle to PostgreSQLNeeta Goel · PGConf India 2025
• 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
• 46mThe Top 10 Mistakes When Migrating Oracle Databases to PostgreSQLJim Mlodgenski · Percona Live 2022
• 31mSimplifying the Top Complexities While Migrating From Oracle to PostgreSQLAvinash Vallarapu · Percona Live 2022
• 24mMigrating from Oracle to Azure Database for PostgreSQL, SeamlesslyNeeta Goel, Sandeep Rajeev · POSETTE: An Event for Postgres 2025
• 44mPostgres for Java DevelopersSergey Valkov · JPoint 2024