Question

  • Creator
    Topic
  • #4022413

    Migration from AWS Aurora to AWS Aurora

    by saichinnu1852 ·

    Tags: 

    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 3 weeks, 4 days ago by Avatar photokees_b.

You are posting a reply to: Migration from AWS Aurora to AWS Aurora

The posting of advertisements, profanity, or personal attacks is prohibited. Please refer to our Community FAQs for details. All submitted content is subject to our Terms of Use.

All Answers

  • Author
    Replies
    • #4022605
      Avatar photo

      Reply To: Migration from AWS Aurora to AWS Aurora

      by Ravi Kiran ·

      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.

Viewing 0 reply threads