Created by Henrique Lobao (AWS), Jonathan Pereira Cruz (AWS), and Vishal Singh (AWS)
|
Environment: PoC or pilot |
Source: Microsoft SQL Server |
Target: Amazon RDS for SQL Server |
|
R Type: Replatform |
Workload: Microsoft |
Technologies: Migration; Databases |
|
AWS services: Amazon RDS |
This pattern provides guidance for migrating from an on-premises Microsoft SQL Server database to Amazon Relational Database Service (Amazon RDS) for SQL Server. It describes two options for migration: using AWS Data Migration Service (AWS DMS) or using native Microsoft SQL Server tools such as Copy Database Wizard.
Prerequisites
An active AWS account
A source Microsoft SQL Server database in an on-premises data center
Limitations
Database size limit: 16 TB
Product versions
SQL Server 2014-2019, Enterprise, Standard, Workgroup, and Developer editions. For the latest list of supported versions and features, see Microsoft SQL Server on Amazon RDS in the AWS documentation. If you're using AWS DMS, see also Using a Microsoft SQL Server Database as a Target for AWS DMS for SQL Server versions supported by AWS DMS.
Source technology stack
An on-premises Microsoft SQL Server database
Target technology stack
An Amazon RDS for SQL Server DB instance
Source and target architecture
