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.