Oracle to PostgreSQL Migration Tutorial
Álvaro is a passionate database and software developer. Founder and CEO of OnGres, an “ON postGRES” startup. Álvaro has been dedicated to PostgreSQL and R&D in databases since two decades ago.
You can find him frequently speaking at PostgreSQL, database, cloud, and Java conferences. Every year, Álvaro travels approximately three-four times around the globe—in 2020, he will hit the milestone of having delivered 100 tech talks.
No video of the event yet, sorry!
Stop paying for Larry’s boat!
PostgreSQL is a fully-featured, enterprise-grade and open source database, named two years in a row database of the year! And it’s also the best candidate to migrate off of Oracle, supporting very advanced SQL, easy administration and pl/pgsql, a replacement for Oracle’s PL/SQL. Stop spending hundreds of thousands or millions of $ on database licenses and reinvest them in your team, infrastructure and software.
Join this full-day tutorial (and/or any of its sessions) to learn the best practices, tricks and tools to perform a successful Oracle to PostgreSQL migration. Learn from the team that performed 150M users Blackberry migration to PostgreSQL on GCP with near-zero downtime, and the key author behind orafce, a set of Oracle compatible functions on top of PostgreSQL.
- Morning Session
- Introduction, Migration Strategy, Steps and Risks
- Oracle and PostgreSQL differences. Tips&tricks
- DDL migration
- Introduction to PL/SQL -> plpgsql migration (business logic conversion)
- Afternoon Session
- Developer, data migration tooling.
- Hands-on-Lab: data migration.
- Hands-on-Lab: PL/SQL -> plpgsql migration
- 2019 March 18 09:00 EDT
- 7 h
- Murray Hill
- Postgres Conference
- Ops and Administration