Case Study

Migrating Oracle to PostgreSQL

Migrating Oracle to PostgreSQL

2.54 cm Contents Contents Features and Benefits 2 Requirements 2 Steps of Migration 3 Assessment 3 Schema Migration 3 Data Migration 4 Functional Testing 4 Performance Testing 4 Switchover 4 Migrating Oracle to PostgreSQL March 2021 Kirk L. Roybal ® support@instaclustr.com 2 Features and Benefits There are a host of features that make PostgreSQL a compelling database platform and many of them are directly related to Oracle. We will focus on the ones that become architecturally interesting for Oracle to PostgreSQL migrations. • PostgreSQL instances are not linked to financial requirements • PostgreSQL foreign data wrappers are superior to federation • PostgreSQL authentication hooks to nearly a

Join for free to read