Overcoming Migration Challenges: From Oracle to PostgreSQL
Presented by:
BAJI SHAIK
Baji Shaik is a Sr. Lead Consultant with AWS ProServe, GCC AMER. He was introduced to databases in 2011 and over the years has worked with Oracle, PostgreSQL, Postgres Advance Server, RedShift, and Greenplum. His background spans a wide depth and breadth of expertise and experience in SQL/NoSQL database technologies. He is a Database Migration Expert and has developed many successful database solutions addressing challenging business requirements for moving databases from on-premises to Amazon RDS and Aurora PostgreSQL/MySQL and worked on tuning the RDS/Aurora PostgreSQL/MySQL databases to perform upto the mark. He is an eminent author, having written several books on PostgreSQL. A few of his recent works include "Procedural Programming with PostgreSQL PL/pgSQL", “PostgreSQL Configuration“, “Beginning PostgreSQL on the Cloud”, and “PostgreSQL Development Essentials“. Furthermore, he has delivered several conference, workshop sessions and published many blogs in aws blog community.
Sameer Malik
Sameer Malik has been working on relational Databases for over 20 years now and is currently working as a Principal Database Solution Architect at AWS focused on RDS and Aurora. Sameer Malik has helped several customers with their migration journey from on-premise commercial Databases to the Open Source Databases such as PostgreSQL. Previous experience includes 1. Working at AWS for more than 6 years as Principal Product Manager and Principal Database Specialist Solution Architecture on RDS/Aurora. 2. Working at Google cloud as Principal Solution Engineer at Google Cloud focused on Cloud SQL for PostgreSQL and AlloyDB for PostgreSQL. 3. Working at Oracle corporation as Principal Exadata Sales Consultant,Principal Advanced Support Engineer at Oracle ACS (platinum support) and led the Performance tuning team for Oracle RAC and Exadata 4. working as a consultant focused on Oracle Database troubleshooting/performance tuning and DBA lead on several consulting companies like DTCC and Equifax.
No video of the event yet, sorry!
Migrating from Oracle to PostgreSQL is a complex, multi-stage process that involves a variety of technologies and skills. This presentation will explore the key challenges faced during this migration, from the initial assessment to the final cutover. We will discuss critical issues such as converting SYSDATE and NUMBER datatypes, which, if not addressed correctly, can significantly impact database performance. The session will also cover the extensive time required to rewrite functionalities like PIVOT and hierarchical queries, and the importance of correctly handling NULL values to prevent application failures. Additionally, we will dive into the complexities of mapping system catalogs and the differences in partitioning between Oracle and PostgreSQL. Attendees will gain valuable insights and practical strategies to navigate these challenges, ensuring a successful and efficient migration process.
- Date:
- 2024 November 6 17:00 PST
- Duration:
- 50 min
- Room:
- Ops: 421
- Conference:
- Seattle 2024
- Language:
- Track:
- Ops
- Difficulty:
- Medium