AWS DMS allows you to use a SQL Server secondary replica in an availability group as a source to migrate data into Amazon Redshift, reducing overhead on the primary replica while capturing ongoing changes for continuous replication.

<div>
<p>This article shows how to use a SQL Server secondary replica in an availability group as the source to migrate data into Amazon Redshift with AWS Database Migration Service (AWS DMS).</p>
<p>Specifically, the article covers:</p>
<ul>
<li>Solution overview</li>
<li>Prerequisites</li>
<li>Configuring a SQL Server availability group secondary replica as the source</li>
<li>Configuring Amazon Redshift as the target</li>
<li>Creating an AWS DMS replication instance</li>
<li>Creating the AWS DMS source endpoint</li>
<li>Creating the AWS DMS target endpoint</li>
<li>Creating an AWS DMS full load and CDC task</li>
<li>Troubleshooting common errors</li>
<li>Cleaning up the resources</li>
</ul>
</div>


Related articles