AWS Prescriptive Guidance
Patterns

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

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