Oracle to PostgreSQL Migration Tutorial
Álvaro is a passionate database and software developer. Founder of OnGres, he has been dedicated to PostgreSQL and R&D in databases for more than two decades.
Álvaro is at heart an open source advocate and developer. He has created software like StackGres, a Platform for running Postgres on Kubernetes. As a well-known member of the PostgreSQL Community, Álvaro founded the non-profit Fundación PostgreSQL and the Spanish PostgreSQL User Group. He has contributed, among others, the SCRAM authentication library to the Postgres JDBC driver.
You can find him frequently speaking at PostgreSQL, database, cloud (becoming an AWS Data Hero in 2019), and Java conferences. In the last 10 years, Álvaro has completed more than 100 tech talks (https://aht.es).
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