Migration tools - AWS Prescriptive Guidance

Migration tools

The following tools are listed in order of logical migration to physical migration.

Oracle Data Pump

Oracle Data Pump is a native tool that comes with Oracle Database. It provides the ability to export and import data and metadata from or to Oracle databases. You can use Oracle Data Pump at the database, tablespace, schema, and object level. Oracle Data Pump supports flexible data extraction options, parallelism, compression, and encryption.

Oracle Data Pump is commonly used to migrate Oracle databases because it provides a high level of compatibility. Oracle Data Pump is an especially suitable option for migrations to different database editions, versions, and endian platforms. Oracle Data Pump is also often used along with other tools, such as AWS Database Migration Service (AWS DMS) and Oracle Recovery Manager (Oracle RMAN), to build comprehensive solutions for complex use cases.

AWS DMS

AWS Database Migration Service (AWS DMS) is a managed service that helps move data to AWS securely. AWS DMS provides both one-time full database copy and change data capture (CDC) technology. The CDC feature can keep the source and target database in sync and minimize downtime during the migration. To migrate large databases, you can use AWS DMS together with other AWS services, such as Amazon S3, AWS Direct Connect, or AWS Snow Family devices.

Oracle GoldenGate

Oracle GoldenGate is a tool that Oracle offers to collect, replicate, and manage transactional data between databases. It provides CDC by interpreting Oracle database transaction logs. Similar to AWS DMS, Oracle GoldenGate is a common option for migrating Oracle Database. For more information, see Using Oracle GoldenGate with Amazon RDS for Oracle.

Oracle GoldenGate is not part of Oracle Database and requires a separate license from Oracle.

Oracle Recovery Manager

Oracle Recovery Manager (RMAN) is a tool provided by Oracle to perform and manage Oracle database backups and restorations. You can use RMAN to back up an Oracle database from on premises and then restore it to an Oracle instance on AWS. RMAN is a physical-level tool that works on data files and log files instead of schemas and objects.

You can use Oracle RMAN with Amazon RDS Custom for Oracle. RMAN is usually combined with other AWS services, such as AWS Direct Connect, AWS DataSync, and Amazon S3, to form an end-to-end migration solution.

Oracle Data Guard

Oracle Data Guard is a built-in feature of Oracle Database that maintains a physical copy of the database and keeps it in sync. It provides the capability to switch over the roles between primary and standby databases, which can minimize downtime during the migration.

Oracle Data Guard can't be directly used with Amazon RDS for Oracle or Amazon RDS Custom for Oracle for migration. Instead, Oracle Data Guard is usually used with AWS services such as Amazon EC2, AWS Direct Connect, or AWS DMS to build a complete migration solution. For example, you can build a physical standby on an EC2 instance using Oracle Data Guard. Then you can use AWS DMS or Oracle Data Pump to migrate data to the target RDS for Oracle instance.