Amit Arora provides a step-by-step guide on migrating a Microsoft SQL Server database to Babelfish for Aurora PostgreSQL using the Compass tool and AWS Database Migration Service (AWS DMS), with the Northwind sample database as an example, and discusses common issues and their potential resolutions.

<div>
<p>This article provides a step-by-step guide for migrating a Microsoft SQL Server database to Babelfish for Amazon Aurora PostgreSQL, using the Babelfish Compass tool and AWS Database Migration Service (DMS).</p>
<p>Specifically, the article covers:</p>
<ul>
<li>Overview of Babelfish architecture and benefits</li>
<li>Generating DDL and performing analysis using Babelfish Compass tool</li>
<li>Creating a Babelfish for Aurora PostgreSQL cluster</li>
<li>Connecting to the Babelfish cluster and recreating the schema</li>
<li>Migrating data from SQL Server to Babelfish using AWS DMS</li>
<li>Common migration issues and potential resolutions</li>
<li>Conclusion and summary</li>
</ul>
</div>


Migrate SQL Server to Babelfish for Aurora PostgreSQL using the Compass tool and AWS DMS

Related articles