Configure Replication Between an On-premises SQL Server and AWS RDS


In this article, we will review how to migrate the data from on-premises SQL Server to AWS RDS for SQL Server using transactional replication. There are several ways to migrate data from on-premises SQL Server to AWS RDS for SQL Server and transactional replication is one among them.

Configuring transactional replication between the on-premises SQL Server instance and AWS RDS SQL Server is different from configuring transactional replication between two on-premises SQL Servers. The following are the high-level steps involved in configuring transactional SQL replication between on-premises SQL Server and AWS RDS for SQL Server.

Creating AWS RDS SQL Server instance.