Linkedin

Migrate Oracle native functions to PostgreSQL using extensions

Project Overview

Project Detail

This migration pattern provides step-by-step guidance for migrating an Amazon Relational Database Service (Amazon RDS) for Oracle database instance to an Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL-Compatible Edition database by modifying the aws_oracle_ext and orafce extensions to PostgreSQL (psql) native built-in code. This will save processing time.

The pattern describes an offline manual migration strategy with no downtime for a multi-terabyte Oracle source database with a high number of transactions.

https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/migrate-oracle-native-functions-to-postgresql-using-extensions.html?did=pg_card&trk=pg_card

To know more about this project connect with us

Migrate Oracle native functions to PostgreSQL using extensions