Migrate an on-premises Microsoft SQL Server database to Amazon RDS for SQL Server
R Type :RePlatform
source :Databases: Relational
target :Amazon RDS for Microsoft SQL Server
tags :microsoft sql server, database, rds
categories :Independent Software Vendor, LifeCycle, Pattern Accreditation, Pattern Provenance, Pattern Type, Software Infrastructure
Summary
This pattern provides guidance for migrating from an on-premises Microsoft SQL Server database to Amazon Relational Database Service (Amazon RDS) for Microsoft SQL Server. It describes two options for migration: using AWS Data Migration Service (AWS DMS) or using native Microsoft SQL Server tools.
Assumptions and Prerequisites
Prerequisites
-
An active AWS account
-
Source Microsoft SQL Server database (version 2005, 2008, 2008 R2, 2012, or 2014 for the Enterprise, Standard, Workgroup, or Developer edition) in an on-premises data center
Li
mitations
-
Database size limit: 16 TB
Architecture
Source technology stack
-
An on-premises Microsoft SQL Server database: version 2005, 2008, 2008 R2, 2012, or 2014 for the Enterprise, Standard, Workgroup, or Developer edition. For a complete, up-to-date list of sources, see Sources for Data Migration in the AWS DMS documentation.
Target technology stack
-
An Amazon RDS for Microsoft SQL Server DB instance (for version support, see the Amazon RDS for SQL Server webpage).
Source and target architecture
Using AWS DMS:
Using native Microsoft SQL Server tools:
Tools Used
Migration options: AWS DMS or native Microsoft SQL Server tools
AWS DMS -AWS Database Migration Service (AWS DMS) supports several types of source and target databases. For details, see AWS DMS Step-by-Step Walkthroughs. If AWS DMS doesn't support the source database, select another method for migrating the data.
Native Microsoft SQL Server tools - Backup and restore; Copy Database Wizard: copy and attach database
Epics
Plan the migration
Tasks
| Title | Description | Skills | Predecessor |
|---|---|---|---|
| Validate the source and target database version and engine. | DBA | ||
| Identify the hardware requirements for the target server instance. | DBA, SysAdmin | ||
| Identify the storage requirements (storage type and capacity). | DBA, SysAdmin | ||
| Choose the proper instance type based on capacity, storage features, and network features. | DBA, SysAdmin | ||
| Identify the network access security requirements for source and target databases. | DBA, SysAdmin | ||
| Identify the application migration strategy. | DBA, SysAdmin |
Configure the infrastructure
Tasks
| Title | Description | Skills | Predecessor |
|---|---|---|---|
| Create a virtual private cloud (VPC). | SysAdmin | ||
| Create security groups. | SysAdmin | ||
| Configure and start an Amazon RDS DB instance. | DBA, SysAdmin |
Migrate data - option 1
Tasks
| Title | Description | Skills | Predecessor |
|---|---|---|---|
| Use native Microsoft SQL Server tools or third-party tools to migrate database objects and data. | DBA |
Migrate data - option 2
Tasks
| Title | Description | Skills | Predecessor |
|---|---|---|---|
| Migrate data with AWS DMS. | DBA |
Migrate the application
Tasks
| Title | Description | Skills | Predecessor |
|---|---|---|---|
| Follow the application migration strategy. | DBA, SysAdmin, AppOwner |
Cut over
Tasks
| Title | Description | Skills | Predecessor |
|---|---|---|---|
| Switch the application clients over to the new infrastructure. | DBA, SysAdmin, AppOwner |
Close the project
Tasks
| Title | Description | Skills | Predecessor |
|---|---|---|---|
| Shut down the temporary AWS resources. | DBA, SysAdmin | ||
| Review and validate the project documents. | DBA, SysAdmin, AppOwner | ||
| Gather metrics around time to migrate, % of manual vs. tool, cost savings, etc. | DBA, SysAdmin, AppOwner | ||
| Close out the project and provide feedback. | DBA, SysAdmin, AppOwner |
References and Help
References
Tutorials and videos
Contact and help
Migration Pattern Library Support: aws-mpl@amazon.com
