Episode

Tales from the Field - Oracle to PostgreSQL migrations

with Adithya Kumaranchath

Video of a conference talk about Oracle to PostgreSQL migrations presented by Adithya Kumaranchath at POSETTE: An Event for Postgres 2024. Enterprises are increasingly making the move from Oracle databases to open source Postgres. This has emerged as one of the most common migration patterns in the recent times. I spent my initial few years of my career working with Oracle and later in PostgreSQL, and for the past 4 years my focus has been on Oracle to PostgreSQL. So, I think am in the best position to compare and talk about both of these database technologies in detail, share key learnings, and experiences from numerous successful (and failed) customers Oracle to PostgreSQL engagements. Some key questions that will be answered in this session: What are the drivers to migrate from Oracle to PostgreSQL? What are the benefits for business stakeholders and what motivates them to make this move? How difficult would it be for the team adopting to PostgreSQL? What tools are available for migration? How can mission critical applications be migrated with near zero downtime? How and why did a few customers fail?

Adithya has been working with customers from various industries across the US, UK, Asia, and Europe, helping customers solve complex data migration problems. He has led on many large-scale, unique, and complex data modernization and migration programs across industries including aerospace, aviation, pharmaceutical, energy, manufacturing, and retail. He spent the early part of his career with Oracle and then now he uses PostgreSQL. Adithya has been assisting customers in the past few years in migrating to Azure Database for PostgreSQL. He has been a speaker in multiple internal and external events such as TechReady, Machine Learning and Data Science conferences. During his career Adithya has been using his skills in technology to make this world a better place to live in.

Chapters

  • 00:00 - Intro
  • 01:09 - Reasons to migrate from Oracle to PostgreSQL
  • 03:16 - Migration challenges
  • 08:21 - 1st Customer Story: Bank in Southeast Asia
  • 13:32 - 2nd Customer Story: Media company in Europe
  • 18:26 - Why Azure Database for PostgreSQL?
  • 23:05 - Migration tips & tricks

Connect

Azure
Azure Database for PostgreSQL