Home icon

How to migrate a large-scale SQL Server database over low bandwidth using AWS Application Migration Service

Microsoft Workloads on AWS Blog



This article provides a step-by-step guide on how to migrate a large-scale SQL Server database over a low bandwidth network using AWS Application Migration Service (AWS MGN), AWS Snowcone, and SQL Server Log Shipping technology.

Specifically, the article covers:

  • Setting up AWS MGN to replicate volumes from on-premises to AWS
  • Transferring on-premises full backup to Amazon S3 using AWS Snowcone
  • Setting up AWS DataSync for file transfers
  • Setting up custom log shipping from on-premises to AWS to replicate transaction logs
  • Migrating the on-premises database server to the destination Amazon EC2 server
  • Conclusion and cleanup steps


Go to article

The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.

Related articles

Jan 3
2024
Migrate SQL Server databases to AWS with minimal downtime using AWS Migration Hub Orchestrator
Mar 4
2024
Optimizing large-scale migration of SQL Server databases to Amazon EC2 using backup metadata
Dec 29
2023
Migrate from SQL Server to Amazon DynamoDB with data transformation using a staging table
Feb 7
2024
Cost optimize database migrations with AWS DMS: Part 1

The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.