Migrate an on-premises Microsoft SQL Server database to Amazon Redshift using AWS DMS - AWS Prescriptive Guidance

Migrate an on-premises Microsoft SQL Server database to Amazon Redshift using AWS DMS

Created by Mark Szalkiewicz (AWS)

R Type: Re-architect

Source: Databases: Relational

Target: Amazon Redshift

Created by: AWS

Environment: PoC or pilot

Technologies: Databases; Migration

Workload: Microsoft

AWS services: Amazon Redshift

Summary

This pattern provides guidance for migrating an on-premises Microsoft SQL Server database to Amazon Redshift using AWS Data Migration Service (AWS DMS).

Prerequisites and limitations

Prerequisites

  • An active AWS account

  • A source Microsoft SQL Server database in an on-premises data center

Product versions

Architecture

Source technology stack

  • An on-premises Microsoft SQL Server database¬†

Target technology stack

  • Amazon Redshift

Data migration architecture

Tools

Epics

TaskDescriptionSkills required
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 the source and target databases.

DBA, SysAdmin
Identify the application migration strategy.

DBA, SysAdmin, App owner
TaskDescriptionSkills required
Create a virtual private cloud (VPC).

See https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_VPC.WorkingWithRDSInstanceinaVPC.html for how to work with a DB instance in a VPC.

SysAdmin
Create security groups.

SysAdmin
Configure and start an Amazon Redshift cluster.

DBA, SysAdmin
TaskDescriptionSkills required
Migrate the data from the Microsoft SQL Server database by using AWS DMS.

DBA
TaskDescriptionSkills required
Follow the application migration strategy.

DBA, SysAdmin, App owner
TaskDescriptionSkills required
Switch the application clients over to the new infrastructure.

DBA, SysAdmin, App owner
TaskDescriptionSkills required
Shut down the temporary resources.

DBA, SysAdmin
Review and validate the project documents.

DBA, SysAdmin, App owner
Gather metrics around time to migrate, % of manual vs. tool, cost savings, etc.

DBA, SysAdmin, App owner
Close out the project and provide feedback.

DBA, SysAdmin, App owner

References

Tutorials and videos