Migrating an Oracle Database to Amazon RDS for Oracle - Database Migration Guide
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Migrating an Oracle Database to Amazon RDS for Oracle

You can use these three main approaches to migrate self-managed Oracle databases to Amazon Relational Database Service (Amazon RDS) for Oracle.

  • Using a native database tool such as Oracle Data Pump.

  • Using a managed service such as the Amazon Database Migration Service (Amazon DMS).

  • Using a native tool for the full load phase and Amazon DMS for ongoing replication.

This document describes the third strategy — we call this the hybrid approach. The following diagram shows the components of the hybrid approach.

Hybrid migration approach

The hybrid approach provides the following advantages.

  • To automate the creation of secondary database objects such as views, indexes, and constraints.

  • To use Amazon DMS data validation to ensure your target data matches with the source, row by row and column by column.

  • To use some of the other capabilities that Amazon DMS provides, for example data filtering or renaming tables and columns.

This document describes the native options for the full load. It also includes a comparison so you can evaluate the options against your migration requirements. In conclusion, you can find a brief description of how to use Amazon DMS for ongoing replication.

Topics