Linked servers enable Microsoft SQL Server to run SQL statements on other instances of database servers. This pattern describes how you can migrate your on-premises Microsoft SQL Server database to Amazon Relational Database Service (Amazon RDS) for Microsoft SQL Server to achieve lower cost and higher availability. Currently, Amazon RDS for Microsoft SQL Server doesn't support connections outside an Amazon Virtual Private Cloud (Amazon VPC) network.
You can use this pattern to achieve the following objectives:
To migrate Microsoft SQL Server to Amazon RDS for Microsoft SQL Server without breaking linked server capabilities.
To prioritize and migrate linked Microsoft SQL Server in different waves.
Prerequisites
Check whether Microsoft SQL Server on Amazon RDS supports the features you require.
Make sure that you can use either Amazon RDS for Microsoft SQL Server with default collations or collations set over database levels.
Source technology stack
On-premises databases (Microsoft SQL Server)
Target technology stack
Amazon RDS for SQL Server
Source state architecture
