Phase 2: Plan

After you gather information about the database during the preparation phase, you decide the migration strategy in the planning phase. There are seven common migration strategies (7 Rs):

For help determining the R type, see the decision tree in Application portfolio assessment guide for AWS Cloud migration. The migration strategy for your database depends on factors such as your business need, time and financial constraints, and resource requirements. However, in a homogeneous migration, where the source and target database engines are both Oracle, the migration strategy is limited to rehost, replatform, and relocate. The migration strategy also helps determine the target. If you choose rehost or relocate as the migration type, the target for Oracle Database is an EC2 instance. If you choose the replatform strategy, the target is Amazon RDS for Oracle or Amazon RDS Custom for Oracle.

The following table lists the supported R types for homogeneous database migrations based on the source Oracle Database technology.

Choosing a migration strategy also depends on the workload. You can use AWS Schema Conversion Tool (AWS SCT) or AWS Database Migration Service (AWS DMS) Schema Conversion to evaluate and decide the migration strategy. The following table shows examples of application workloads and their corresponding migration strategies.