Q. What is Amazon Aurora?
Amazon Aurora is a MySQL-compatible relational database engine that combines the speed and availability of high-end commercial databases, such as Oracle, with the simplicity and cost-effectiveness of open source databases such as MySQL.
Q. Why should I migrate data to Amazon Aurora?
Amazon Aurora is a cost-effective and fully-managed service that provides security, availability, and reliability of a commercial database, at one-tenth the cost. Amazon Aurora is also compatible with Amazon Relational Database Service (RDS), a service that handles time-consuming tasks such as provisioning, patching, and backup, recovery, failure detection, and repair.
Q: What is AWS Database Migration Service (DMS) and what are the benefits of using it for migration?
AWS Database Migration Service (DMS) is a low-cost service to help you migrate databases to AWS easily and securely. Replication tasks can be set up in minutes instead of hours or days, compared to self-managed replication solutions that have to be installed and configured. AWS DMS data replication integrates tightly with the AWS Schema Conversion Tool, simplifying heterogeneous database migration projects such as Oracle to Aurora.
Q: What is the AWS Schema Conversion Tool (SCT)?
The AWS Schema Conversion Tool (SCT) makes heterogeneous database migrations easy by automatically converting the source database schema from Oracle and a majority of the custom code, including views, stored procedures, and functions, to a format compatible with the target database such as Aurora. Any code that cannot be automatically converted is clearly marked so that it can be manually converted.
Q: In which AWS regions are Amazon Aurora and AWS DMS service available?
Q: What is a CloudFormation stack?
A CloudFormation stack is a collection of AWS resources that you can manage as a single unit. The resources in a stack are defined by the stack's CloudFormation template. In this project, you will use a CloudFormation stack to create and provision the VPC, subnets, security groups, and RDS instances you need to complete the databse migration from Oracle to Aurora. After completion of the project, you can easily delete the stack to avoid incurring additional charges.
Q: Can I customize the CloudFormation template used in this project?
Yes. The CloudFormation template is designed to obtain a few inputs from the user and provision the required AWS services with minimum configurations. However, if you would like to amend some of the configurations such as VPC CIDR block, RDS instance types, etc., you can update the template and launch it.
Q. Does AWS DMS and SCT support migration of complex database schemas?
Yes. This project helps in understanding the methodology to be used for heterogeneous database migrations using a simple schema structure. This experience can aid in the migration of complex database scenarios.
Q. Does AWS DMS service support only full-data migration, as illustrated in this project?
No. You can use AWS DMS for one-time full-data migration, as well as continuous data replication (CDC). AWS DMS captures changes on the source database and applies them in a transactionally-consistent way to the target. The only change you need to do is in the Task settings. Create a new task with CDC enabled, and then the data replication task will run until you change or terminate it.
Q: How much will it cost to run this project?
The costs associated with your migration project will be less than $5, assuming it is completed within 2 hours. For more details, see Services Used and Costs.