Date: 2024-09-30
Time: 15:00–15:50
Room: Club Parlor
Level: Intermediate
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.