Cost to Migrate: Typically, it will cost about $7.85 for a one-time migration of a 10 GB Oracle data warehouse, as illustrated in this sample project. This cost assumes that you are within the AWS Free Tier limits, you follow the recommended configurations, and that you terminate all resources within 2 hours of completing the project.
Cost to Maintain: The total cost of maintaining your data warehouse in Amazon Redshift will vary depending on your usage and configuration settings. Using the default configuration recommended in this guide, it will typically cost $45.84 a month if you are within the AWS Free Tier limits. Your use case may require different configurations that can impact your bill. Use the Pricing Calculator to estimate costs tailored for your needs.
Individual service usage and cost: AWS pricing is based on your usage of each individual service. The total combined usage of each service will create your monthly bill. Explore the tabs below to learn what each service does and how it affects your bill.
-
Amazon Redshift
Description: Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse that makes it simple and cost-effective to analyze all your data using your existing business intelligence tools.
How Pricing Works: Amazon Redshift pricing is based on four components: the node types you choose (dense compute or dense storage), the number of nodes, the region your clusters are based in and the pricing model you select (on-demand or reserved). For more information, see Amazon Redshift Pricing.
Cost Example: This project will set up an environment that runs on single node dc1.large cluster in US-West-2. This will cost approximately $0 per month (assuming you are within the AWS Free Tier limit), and $183 per month if you are outside the AWS Free Tier limit.
-
Amazon RDS for Oracle
Description: Amazon Relational Database Service (RDS) makes it easy to set up, operate, and scale a relational database in the cloud. It provides cost-efficient and resizable capacity while managing time-consuming database administration tasks. AWS RDS Oracle Standard Edition One (SE1) with license included option is provisioned as a source database in this project.
How Pricing Works: RDS Oracle pricing includes four components: number of hours your instance is running, amount of database storage consumed, backup storage, and data transfer in/out of RDS. Also, please note that “License Included" pricing is inclusive of Oracle software license, underlying hardware resources, and Amazon RDS management capabilities. For more information, see Amazon RDS Pricing.
Example: This project provisions the db.m3.medium instance with 50 GB GP2 (General Purpose) storage in the US-West-2 (Oregon) region (Single-AZ deployment). With an on-demand pricing model, your charge will be $4.98 for two hours.
-
AWS Database Migration Service
Description: AWS Database Migration Service helps you migrate databases to AWS easily and securely at a low cost.
How Pricing Works: You only pay for the compute resources used during the migration process and any additional log storage. Each database migration instance includes storage sufficient for swap space, replication logs, and data cache, for most replications and inbound data transfer is free. For more information, see AWS DMS Pricing.
Example: In this project, you will provision a t2.medium instance with 50GB log storage in US-West-2 (Oregon) region (Single-AZ deployment). With an on-demand pricing model, your charge to keep the DMS instance running for two hours will be $2.87.
-
AWS Schema Conversion Tool
Description: The AWS Schema Conversion Tool (SCT) is used to convert the Oracle database schema, including views and stored procedures, to a format compatible with Aurora database. AWS SCT is available for Microsoft Windows, Mac OS X, Ubuntu Linux version 15.04, and Fedora Linux.
How Pricing Works: AWS SCT is a free tool, provided as part of the AWS DMS service.
