Search code examples
amazon-rds

how to transfer/migrate data from Source Oracle DB to aws oracle rds

I have a request to move Source Oracle DB into AWS Oracle RDS. I research on AWS page to find out the solution, but AWS guide very complex such as upload dump file to S3, download file dump...I don't want to do on this way because it very take time. Any one have any solution to move database to AWS Oracle RDS?

My updated: Source Oracle DB is not use any AWS service. It only installed on phycical server.

Please help share any solution/tools can use to migrate

Solution

  • You can use SQL Developer Tool to copy database from source to AWS Oracle RDS (I am using SQL Developer Tool version 19.2.1.247) enter image description here

    Before migrate you need the below things to prepare/configure on AWS Oracle RDS, to ensure the same with Source Oracle DB

    1. Create the same user who assigned to your schema/database
    2. If Source Oracle DB is using tablespace, you must be create the same tablespace

    After prepared, You will do the below steps on SQL Developer Tool

    1. Using admin account to created a connect to Source Oracle DB server.

    2. Using admin account to created a connect to Oracle AWS server. enter image description here

    3. Go to Tools -> Database Copy... enter image description here

    4. On Dialog, choose source db and destination db enter image description here

      INFO:If you are using tablespace on source db, you must be choose [Tablespace Copy] like that:

      enter image description here

    5. Click Next to continue and waiting to transfer.