Importing data into Oracle on Amazon RDS - Amazon Relational Database Service

Importing data into Oracle on Amazon RDS

How you import data into an Amazon RDS for Oracle DB instance depends on the following:

  • The amount of data you have

  • The number of database objects in your database

  • The variety of database objects in your database

For example, you can use the following tools, depending on your requirements:


Before you use the preceding migration techniques, we recommend that you back up your database. After you import the data, you can back up your RDS for Oracle DB instances by creating snapshots. Later, you can restore the snapshots. For more information, see Backing up and restoring an Amazon RDS DB instance.

For many database engines, ongoing replication can continue until you are ready to switch over to the target database. You can use AWS DMS to migrate to RDS for Oracle from either the same database engine or a different engine. If you migrate from a different database engine, you can use the AWS Schema Conversion Tool to migrate schema objects that AWS DMS doesn't migrate.

The following video summarizes the different Oracle Database migration techniques.

The following video explains how to plan and execute a data migration.