which is the best way to migrate Oracle data to postgres

@All Try to avoid posting external links, @Amira use default font

For on premise migrations - ora2pg is a good tool that you may want to explore

Solution :

- Migrate Schema using AWS SCT

- Drop foreign keys and secondary indexes on the target database, and disable triggers.

- Perform full load and change data capture (CDC) using AWS DMS

Hi, you can follow this link:

https://www.enterprisedb.com/postgres-tutorials/how-import-data-oracle-postgresql

https://www.enterprisedb.com/blog/the-complete-oracle-to-postgresql-migration-guide-tutorial-move-convert-database-oracle-alternative

Check this as well:

https://www.enterprisedb.com/blog/the-complete-oracle-to-postgresql-migration-guide-tutorial-move-convert-database-oracle-alternative

Try this link:

https://severalnines.com/database-blog/migrating-oracle-postgresql-what-you-should-know