AWS Aurora to Redshift: 9 Easy Steps to Migrate Data Using AWS DMS

on Tutorial • September 7th, 2021 • Write for Hevo

AWS Data Migration Service (DMS) is a Database Migration service provided by Amazon. Using DMS, you can migrate your data from one Database to another Database. It supports both, Homogeneous and Heterogeneous Database Migration. DMS also supports migrating data from the on-prem Database to AWS Database services.

In this article, you will be introduced to AWS DMS. You will understand the steps to load data from Amazon Aurora to Redshift using AWS DMS. You also explore the pros and cons associated with this method. So, read along to gain insights and understand the loading of data from Aurora to Redshift using AWS DMS.

Table of Contents

Introduction to AWS Data Migration Service (DMS)

Using AWS Data Migration Service (DMS) you can migrate your tables from Aurora to Redshift. You need to provide the source and target Database endpoint details along with Schema Names. DMS uses a Replication Instance to process the Migration task. In DMS, you need to set up a Replication Instance and provide the source and target endpoint details. Replication Instance reads the data from the source and loads the data into the target. This entire processing happens in the memory of the Replication Instance. For migrating a high volume of data, it is recommended to use Replication Instances of higher instance classes.

To explore more about AWS DMS, visit here.

Steps to Move Data from Aurora to Redshift using AWS DMS

  1. Let us create a table in Aurora (Table name redshift.employee). We will move the data from this table to Redshift using DMS.
aurora to redshift move data from table using dms
  1. We will insert some rows in the Aurora table before we move the data from this table to Redshift.
move data from aurora to redshift using aws dms
  1. Go to the DMS service and create a Replication Instance.
aurora to redshift create replication instance
create replication instance move aurora to redshift
  1. Create source and target endpoint and test the connection from the Replication Instance.
connect source target database for aurora to redshift
test connection for aurora to redshift
create endpoint aurora to redshift
test connection aurora to redshift

Once both the endpoints are created, it will look as shown below:

create endpoint for aurora to redshift
  1. Once Replication Instance and endpoints are created, create a Replication task. The Replication task will take care of your migration of data.
create task aurora to redshift migration
task settings for aurora to redshift
  1. Select the table name and schema, which you want to migrate. You can use % as wildcards for multiple tables/schema.
aurora to redshift selection rules
  1. Once setup is done, start the Replication task.
create task aurora to redshift replication
  1. Once the Replication task is completed, you can see the entire details along with the assessment report.
create task dms aurora to redshift
  1. Now, since the Replication task has completed its activity, let us check the data in Redshift to know whether the data has been migrated.
aurora to redshift migrate data

As shown in the steps above, DMS is pretty handy when it comes to Replicating data from Aurora to Redshift but it requires performing a few manual activities.

Pros of Moving Data from Aurora to Redshift using AWS DMS

  • Data movement is secure as Data Security is fully managed internally by AWS.
  • No Database downtime is needed during the Migration.
  • Replication task setup requires just a few seconds.
  • Depending upon the volume of Data Migration, users can select the Replication Instance type and the Replication task will take care of migrating the data.
  • You can migrate your data either in Full mode or in CDC mode. In case your Replication task is running, a change in the data in the source Database will automatically reflect in the target database.
  • DMS migration steps can be easily monitored and troubleshot using Cloudwatch Logs and Metrics. You can even generate notification emails depending on your rules.
  • Migrating data to Redshift using DMS is free for 6 months.

Cons of Moving Data from Aurora to Redshift using AWS DMS

  • While copying data from Aurora to Redshift using AWS DMS, it does not support SCT (Schema Conversion Tool) for your Automatic Schema conversion which is one of the biggest demerits of this setup.
  • Due to differences in features of the Aurora Database and Redshift Database, you need to perform a lot of manual activities for the setup i.e. DMS does not support moving Stored Procedures since in Redshift there is no concept of Stored Procedures, etc.
  • Replication Instance has a limitation on storage limit. It supports up to 6 TB of data.
  • You cannot migrate data from Aurora from one region to another region meaning both the Aurora Database and Redshift Database should be in the same region.

Easier Way to move data from Aurora to Redshift

Using the Hevo Data Integration Platform, you can seamlessly transfer data from Aurora to Redshift using 3 simple steps.

  • Connect and configure your Aurora database.
  • Select the Replication mode: (a) Load selected Aurora tables (b) Load data via Custom Query (c) Load data through Binlog.
  • For each table in Aurora choose a table name in Redshift where it should be copied.

While you unwind, Hevo will take care of retrieving the data and transferring it to your destination Warehouse. Unlike AWS DMS, Hevo provides you with an error-free, fully managed setup to move data in minutes. You can check a detailed article to compare Hevo vs AWS DMS.



Overall the DMS approach of replicating data from Aurora to Redshift is satisfactory, however, you need to perform a lot of manual activities before the data movement. Few features that are not supported in Redshift have to be handled manually as SCT does not support Aurora to Redshift data movement.

In a nutshell, if your manual setup is ready and taken care of you can leverage DMS to move data from Aurora to Redshift. You can also refer to our other blogs where we have discussed Aurora to Redshift replication using AWS Glue and AWS Data Pipeline.


In case you wish to extract complex data from a diverse set of data sources like Salesforce and other CRMs, Hevo is the right choice for you! Hevo Data is a No-Code Data Pipeline that offers a faster way to move data from 100+ Data Sources including 30+ Free Sources, into your Data Warehouse such as Amazon Redshift to be visualized in a BI tool. Hevo is fully automated and hence does not require you to code.

Want to take Hevo for a spin?

SIGN UP and experience the feature-rich Hevo suite first hand. You can also have a look at the unbeatable pricing that will help you choose the right plan for your business needs.

Share your experience of loading data from AWS Aurora to Amazon Redshift in the comments section below!

No-code Data Pipeline for Redshift