By using AWS re:Post, you agree to the Terms of Use

Database Migration


What is the best possible way to migrate the legacy on-premises Oracle database into AWS RDS(Postgres) without changing the schema of the existing database tables?

2 Answers


AWS has documentation on how to do this. Check out this page: Migrating an Oracle Database to PostgreSQL

profile picture
answered 22 days ago

Postgres DDL (Data Definition Language) and Oracle DDL are slightly different. This will be a heterogeneous migration.

You can use AWS SCT (Schema conversion tool) to convert the Oracle schema to a Postgres schema.

Once the schema has been created on the destination Postgres DB you'll use DMS (Database migration tool) to migrate the data.

profile picture
answered 18 days ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions