Home icon

Migrate SQL Server databases to AWS with minimal downtime using AWS Migration Hub Orchestrator

Microsoft Workloads on AWS Blog



This article provides a step-by-step guide on how to use AWS Migration Hub Orchestrator to migrate SQL Server databases from on-premises to Amazon EC2 or Amazon RDS with minimal downtime by leveraging transaction log backups.

Specifically, the article covers:

  • Solution overview and prerequisites for the migration
  • Walkthrough of creating a migration workflow in AWS Migration Hub Orchestrator
  • Detailed steps for configuring source and target environments, performing backups, and executing the cutover
  • How Migration Hub Orchestrator automates the transaction log backup and restore process during cutover to reduce downtime
  • Cleanup instructions for deleting the migration workflows


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 2
2024
How to migrate a large-scale SQL Server database over low bandwidth using AWS Application Migration Service
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.