Presented by:

Álvaro is a passionate database and software developer. Founder of OnGres ("ON postGRES"), he has been dedicated to Postgres 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; or ToroDB (MongoDB on top of Postgres), both open source projects.

As a well- known member of the PostgreSQL Community, Álvaro founded the non-profit Fundación PostgreSQL (organizer of PostgreSQL Ibiza conference) 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, Java and cloud (becoming an AWS Data Hero in 2019) conferences. In the last 10 years, Álvaro has completed more than 140 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.

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 EDT
Duration:
7 h
Room:
Murray Hill
Conference:
Postgres Conference
Language:
Track:
Ops and Administration
Difficulty:
Medium