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!
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 tutorial 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.
- Introduction, Migration Strategy, Steps and Risks
- Oracle and PostgreSQL differences. Tips&tricks
- DDL migration
- Introduction to PL/SQL -> plpgsql migration (business logic conversion)
- 2019 September 18 13:00
- 3 h
- Winchester (1)
- Silicon Valley 2019
- Ops and Administration
- Requires Registration:
- Yes (Registered: 15)