If using AWS DMS is not allowed in your customer's AWS account, there are alternative approaches you can consider for migrating from a local Oracle database to AWS Aurora (Postgres). Here are a couple of options:
Database Dump and Restore
a. Export the data from your local Oracle database using tools like Oracle Data Pump or Export/Import utilities.
b. Create a new AWS Aurora (Postgres) instance in your AWS account.
c. Import the exported data into the Aurora instance using tools like pg_dump and pg_restore.
Database Replication
a. Set up replication between your local Oracle database and the AWS Aurora (Postgres) instance.
b. Use tools like Oracle GoldenGate or Oracle Data Guard to replicate the data changes from Oracle to Aurora.
c. Once replication is established, switch the application connections to use the AWS Aurora (Postgres) instance.
It is important to note that both options require careful planning and consideration of data compatibility, schema mapping, data validation, and application dependencies. It is recommended to engage database and migration experts to ensure a smooth and successful migration process.
Additionally, you should consult with your customer's IT or compliance department to understand the specific rules and regulations regarding data migration and the use of third-party tools in their AWS account. They will provide guidance on the allowed migration methods and any necessary approvals or alternatives to ensure compliance.