Other·307 discussions

[kees_b]

Migration from AWS Aurora to AWS Aurora

Locked

Tags: Software

We were planning to migrate from local Oracle database to AWS Aurora(Posgres) in my customer’s AWS account with AWS DMS, but my customer told us they don’t know whether AWS DMS is allowed to use or not in their AWS account(due to their company rule). So, we are planning to do follow action in case of AWS DMS is impossible.

First: Migrate from local Oracle database to AWS Aurora(Posgres) in our AWS account with AWS DMS.
Second: Migrate from AWS Aurora(Posgres) in our AWS account to AWS Aurora(Posgres) in my customer’s AWS account.

I tried searching how to migrate, but could’t find the answer.
Does anyone know the idea?

Note: commercial link removed by moderator.

• This topic was modified 2 years, 2 months ago by kees_b.

Topic

Reply To: Migration from AWS Aurora to AWS Aurora

In reply to Migration from AWS Aurora to AWS Aurora

If your customer’s company rules do not allow the use of AWS DMS for migrating the Oracle database to Aurora Postgres in their AWS account, there are a few other options you can consider:

Use the pgAdmin tool to export data from the Oracle database in the local environment and import it into the Aurora Postgres database in your AWS account. This tool can be used to export data in a format that can be imported into Postgres, such as SQL or CSV.

Use the AWS Schema Conversion Tool (SCT) to convert the Oracle schema to a Postgres schema and then use the pgAdmin tool or the AWS Data Migration Service (DMS) to transfer the data. SCT allows you to convert the Oracle schema to a format that is compatible with Aurora Postgres.

Use a third-party tool such as Oracle Data Pump or the Toad for Oracle software to export the data from the local Oracle database and import it into the Aurora Postgres database in your AWS account.

Once you have the data in your AWS account, you can use the AWS Data Migration Service (DMS) to migrate the data from your Aurora Postgres database to the customer’s Aurora Postgres database in their AWS account.

It’s important to note that migrating from one database to another can be a complex task and it’s recommended that you test the migration process in a non-production environment before migrating the data to the production environment.

Reply To: Migration from AWS Aurora to AWS Aurora

In reply to Migration from AWS Aurora to AWS Aurora

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.

[Author]

Replies