Migrating your Oracle database to Amazon Aurora can substantially reduce your database costs, while improving reliability and performance. Amazon Aurora is a fully-managed high-performance database with the security, availability, and reliability of a commercial database, at one-tenth the cost. AWS Database Migration Service and AWS Schema Conversion Tool make it easier to perform this migration with minimal disruption to the applications that rely on the source database.
What you'll accomplish:
Convert database schema and code using AWS Schema Conversion Tool. It will help you automatically convert the source database schema and SQL in your C++, C#, Java or other application code to a format compatible with Amazon Aurora. Any code that cannot be automatically converted is clearly marked so that it can be manually converted.
Migrate data from the source database to the target database using AWS Database Migration Service. You can begin the data migration with just a few clicks in the AWS Management Console. The source database remains fully operational during the migration
Perform post-migration activities such as running SQL queries for validating the object types, object count, and the number of rows for each table between source and target databases.
What you'll need before starting:
An AWS Account: You will need an AWS account to begin provisioning resources to host your website. Sign up for AWS.
IT Skill level: Basic knowledge of Oracle and SQL is required to successfully complete this project.
AWS Experience: Basic knowledge of AWS Virtual Private Cloud, Amazon RDS, Amazon DMS, security groups, and CloudFormation is required to successfully complete this project.
Monthly Billing Estimate:
The total cost of migrating your Oracle database to Amazon Aurora will vary depending on several things: the size of your database, the Amazon Aurora instance type, and AWS DMS instance type you select, any additional storage needed, and your usage. Typically, it will cost about $5 for a one-time migration of an Oracle database of size 10 GB, as illustrated in this sample project. To see a breakdown of the services used and their associated costs, see Services Used and Costs.
Virtusa is an AWS Partner Network (APN) Premier Partner. Our consulting offerings will help you rationalize your data assets and layout the data modernization roadmap. Additionally, our proven delivery methodology, expertise in AWS stack and a certified pool of global consultant base will migrate traditional RDBMS platforms including Oracle & SQL Server to Amazon Aurora or any other AWS database service.
Leverage DB Best’s cloud database migration and optimization expertise on AWS to successfully migrate from Oracle to Amazon Aurora. This can help you increase business flexibility, accelerate the deployment of database solutions, and realize the benefits of the breadth and depth of AWS. Learn more in DB Best’s eBook, architecture overview, and their discounted Jumpstart offer.
Enhance your Amazon Aurora data warehouse by working with industry-leading tools and experts who can help you learn how to do more with Amazon Aurora - from migrating data to scaling up your MySQL deployments.
See additional information on working with Amazon Aurora, including tutorials, documentation, and best practices.
This whitepaper outlines best practices for using AWS DMS.
Need more resources to get started with AWS? Visit the Getting Started Resource Center to learn more.
