This post demonstrates how to migrate a data warehouse from Microsoft Azure Synapse to Amazon Redshift Serverless using AWS Schema Conversion Tool (SCT) and data extraction agents, making the migration process more predictable by automatically converting the source database schema and data.

<div>
<p>This article provides a step-by-step guide for migrating a data warehouse from Microsoft Azure Synapse Analytics to Amazon Redshift Serverless using the AWS Schema Conversion Tool (AWS SCT) and data extraction agents.</p>
<p>Specifically, the article covers:</p>
<ul>
<li>Creating a Redshift Serverless data warehouse and S3 bucket</li>
<li>Converting and applying the Azure Synapse schema to Redshift using AWS SCT</li>
<li>Migrating data from Azure Synapse to Redshift using AWS SCT data extraction agents</li>
<li>Viewing the migrated data in Redshift</li>
<li>Cleaning up the resources created</li>
</ul>
<p>The solution enables migrating database objects and data from Azure Synapse to Redshift Serverless, benefiting from Redshift's scalability, performance, and integration with other AWS analytics services.</p>
</div>


Migrate Microsoft Azure Synapse Analytics to Amazon Redshift using AWS SCT

Related articles