Oracle to PostgreSQL Migration Tutorial
Álvaro is a passionate database and software developer. He has been an almost exclusive user of PostgreSQL, as THE database, for more than 15 years. Founder of OnGres, he is dedicated to R&D in databases. Álvaro founded ToroDB, previously the “Billion Tables Project” and keeps working on innovative open source solutions for databases, specially PostgreSQL. On his free time he also contributes to open source and PostgreSQL, like SCRAM's support in PostgreSQL's JDBC driver.
He is a frequent speaker at PostgreSQL, database and Java conferences. Álvaro created the Spanish PostgreSQL user group, one of the largest in the world, with 750+ members.
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
- 6 h
- Sugar Hill
- Postgres Conference
- Ops and Administration