We are planning to Migrate our DB from Oracle 12c to PostgreSQL AWS PostgreSQL
We are planning to Migrate our DB from Oracle 12c to latest AWS PostgreSQL and looking for suggestions what is the best way to do it by considering Live environment upgrade (Data in Blob format, enable search functionality, Running Reports in old DB Oracle during migration process).Also suggest the cutover methodology for the same.
Also suggest what is the best possible approach to migrate data from Oracle to AWS Postgres SQL.
Running scripts or any built-in tools or any other approach we can do better.
Please suggest any reference document or steps to follow for the migration process.