Database Migration

Hello,

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

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.

Hello,

This is doable. Schema name and tables names most likely does not required to be changed, few exception where names are keyword etc.

Using AWS Schema conversion tool we can assess Oracle database for conversion efforts and also it can give you converted code.

You may check the playbook and documentation to get better idea how this can he carried out.

https://docs.aws.amazon.com/dms/latest/oracle-to-aurora-postgresql-migration-playbook/chap-oracle-aurora-pg.html

https://d1.awsstatic.com/whitepapers/Migration/oracle-database-amazon-aurora-postgresql-migration-playbook-12.4.pdf

in any case, changes will occur during the migration, but the target database will retain the same functionality as the source one. you can use the following software for oracle to postgresql migration. these changes will be the same, no matter where your oracle and postgres are located