Learn how to migrate an Amazon RDS for Oracle database to an RDS for PostgreSQL DB instance in another AWS account with no downtime and minimal data loss. This article covers using AWS Schema Conversion Tool (AWS SCT) and AWS Database Migration Service (AWS DMS) for a successful migration.
Table of Contents
Question
A company is planning to migrate an Amazon RDS for Oracle database to an RDS for PostgreSQL DB instance in another AWS account. A solutions architect needs to design a migration strategy that will require no downtime and that will minimize the amount of time necessary to complete the migration. The migration strategy must replicate all existing data and any new data that is created during the migration. The target database must be identical to the source database at completion of the migration process.
All applications currently use an Amazon Route 53 CNAME record as their endpoint for communication with the RDS for Oracle DB instance. The RDS for Oracle DB instance is in a private subnet.
Which combination of steps should the solutions architect take to meet these requirements? (Choose three.)
A. Create a new RDS for PostgreSQL DB instance in the target account. Use the AWS Schema Conversion Tool (AWS SCT) to migrate the database schema from the source database to the target database.
B. Use the AWS Schema Conversion Tool (AWS SCT) to create a new RDS for PostgreSQL DB instance in the target account with the schema and initial data from the source database.
C. Configure VPC peering between the VPCs in the two AWS accounts to provide connectivity to both DB instances from the target account. Configure the security groups that are attached to each DB instance to allow traffic on the database port from the VPC in the target account.
D. Temporarily allow the source DB instance to be publicly accessible to provide connectivity from the VPC in the target account. Configure the security groups that are attached to each DB instance to allow traffic on the database port from the VPC in the target account.
E. Use AWS Database Migration Service (AWS DMS) in the target account to perform a full load plus change data capture (CDC) migration from the source database to the target database. When the migration is complete, change the CNAME record to point to the target DB instance endpoint.
F. Use AWS Database Migration Service (AWS DMS) in the target account to perform a change data capture (CDC) migration from the source database to the target database. When the migration is complete, change the CNAME record to point to the target DB instance endpoint.
Answer
A. Create a new RDS for PostgreSQL DB instance in the target account. Use the AWS Schema Conversion Tool (AWS SCT) to migrate the database schema from the source database to the target database.
C. Configure VPC peering between the VPCs in the two AWS accounts to provide connectivity to both DB instances from the target account. Configure the security groups that are attached to each DB instance to allow traffic on the database port from the VPC in the target account.
E. Use AWS Database Migration Service (AWS DMS) in the target account to perform a full load plus change data capture (CDC) migration from the source database to the target database. When the migration is complete, change the CNAME record to point to the target DB instance endpoint.
Explanation
To migrate an Amazon RDS for Oracle database to an RDS for PostgreSQL DB instance in another AWS account with no downtime and minimal time, the following steps should be taken:
- Create a new RDS for PostgreSQL DB instance in the target account. This can be done using the AWS Management Console, AWS CLI, or an Infrastructure as Code (IaC) tool such as AWS CloudFormation or Terraform.
- Use the AWS Schema Conversion Tool (AWS SCT) to migrate the database schema from the source database to the target database. AWS SCT is a utility that helps convert the schema of the source database to the target database. It can convert the schema of the Oracle database to a PostgreSQL-compatible schema.
- Use AWS Database Migration Service (AWS DMS) in the target account to perform a full load plus change data capture (CDC) migration from the source database to the target database. AWS DMS is a service that can migrate data from a variety of sources to a variety of targets. It can perform a full load of the data from the source database to the target database, and then continue to replicate any changes that occur on the source database to the target database.
- Configure VPC peering between the VPCs in the two AWS accounts to provide connectivity to both DB instances from the target account. This involves creating a VPC peering connection between the VPC in the source account and the VPC in the target account. Once the VPC peering connection is established, the security groups attached to each DB instance can be configured to allow traffic on the database port from the VPC in the target account.
Options B and D are not the best options because they do not allow for a no-downtime migration. Option B does not provide a way to replicate new data that is created during the migration, and option D involves making the source DB instance publicly accessible, which is not a best practice for security reasons.
Option F is not the best option because it only performs a change data capture (CDC) migration, which means it will not migrate the initial data from the source database to the target database.
Amazon AWS Certified Solutions Architect – Professional SAP-C02 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Amazon AWS Certified Solutions Architect – Professional SAP-C02 exam and earn Amazon AWS Certified Solutions Architect – Professional SAP-C02 certification.