Presented by:

Á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.

Álvaro is at heart an open source advocate and developer. Well-known member of the PostgreSQL Community, he has founded the non-profit Fundación PostgreSQL and the Spanish PostgreSQL User Group.

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.

AWS Data Hero (2019)

Website: 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.

Tentative schedule:

  1. Morning Session
    • Introduction, Migration Strategy, Steps and Risks
    • Architecture
    • Oracle and PostgreSQL differences. Tips&tricks
    • DDL migration
    • Introduction to PL/SQL -> plpgsql migration (business logic conversion)
  2. Afternoon Session
    • Developer, data migration tooling.
    • Hands-on-Lab: data migration.
    • Hands-on-Lab: PL/SQL -> plpgsql migration

Date:
2019 March 18 09:00
Duration:
7 h
Room:
Murray Hill
Conference:
Postgres Conference
Language:
Track:
Ops and Administration
Difficulty:
Medium