Why should you migrate?

AWS provides a comprehensive set of services and tools to deploy your Microsoft SQL Server databases on AWS Cloud infrastructure.

Microsoft SQL Server on AWS

AWS supports everything you need to build and run Windows applications, including Active Directory, .NET, Microsoft SQL Server, Windows desktop-as-a-service, and supported versions of Windows Server.

Amazon RDS Custom

Amazon RDS Custom is a managed database service for applications that require customization of the underlying operating system and database environment.

How do you choose the right migration strategy?

Choosing the correct strategy depends on your business requirements, resource constraints, migration timeframe, and cost considerations.

Migration strategy for relational databases

Don't limit yourself to the same old-guard database you were using on-premises. Instead, modernize your applications and choose databases that best suit your applications' workflow requirements.

Migration and modernization strategies for your SQL Server workloads on AWS

There are three main migration and modernization paths that you can consider for your SQL Server workloads.

What are the available migration methods?

Review the following resources and then use the guidance provided according to your use case.

SQL Server database migration methods

You can choose from AWS services and SQL Server native features based on your assessment and requirements.

Migrate end of support Microsoft SQL Server databases to Amazon RDS for SQL Server confidently

This post demonstrates how to migrate any older version (and EOS) of Microsoft SQL Server databases to Amazon RDS for SQL Server 2019 using backward compatibility.

Migrate on-premises SQL Server to Amazon RDS Custom for SQL Server

This post demonstrates how to migrate a self-managed SQL Server database to Amazon RDS Custom for SQL Server using native backup and restore functionality through Amazon S3.

Migrating your on-premises SQL Server Windows workloads to Amazon EC2 Linux

The post demonstrates setting up the prerequisites to run the replatforming assistant and provides two example use cases.

Migrating SQL Server to Amazon RDS using native backup and restore

This post demonstrates how to use the SQL Server backup and restore features to migrate to Amazon RDS for SQL Server.

Migrating your SQL Server database to Amazon RDS for SQL Server using AWS DMS

This post provides a solution for migrating your on-premises SQL Server database to Amazon RDS for SQL Server using the SQL Server backup and restore method with AWS DMS to minimize downtime.

Automate on-premises or Amazon EC2 SQL Server to Amazon RDS for SQL Server migration

This post examines a use case in which you migrate your Microsoft SQL Server databases to Amazon RDS for SQL Server.

Migrating to Amazon RDS for SQL Server using transactional replication

The solution uses an EC2 instance with SQL Server database engine installation as the on-premises source database and Amazon RDS for SQL Server as the target database for migration.

Migrate TDE-enabled SQL Server databases to Amazon RDS for SQL Server

This post shows you how to migrate a TDE-enabled database from on premises or SQL Server on Amazon Elastic Compute Cloud (Amazon EC2) to Amazon RDS for SQL Server.

Migrating SQL Server databases from Microsoft Azure to AWS in near-real time with CloudBasic

This post presents a solution that uses CloudBasic and other AWS services to facilitate a seamless, near-zero-downtime migration of Azure SQL databases into Amazon RDS for SQL Server.

Migrate SQL Server databases from an Azure SQL database to Amazon RDS for SQL Server

This post demonstrates the process to migrate Azure SQL databases to Amazon RDS for SQL Server.

Migrate a multi-TB SQL Server database to Amazon RDS Custom for SQL Server

This post demonstrates how to migrate a multi-TB database to Amazon Relational Database Services (Amazon RDS) Custom for SQL Server.

Migrate an on-premises SQL Server standalone workload to Amazon RDS Custom for SQL Server

This post provides you a database migration pattern solution for your on-premises SQL Server standalone workload to Amazon RDS Custom, using a domain-independent Always On availability group.

Using AWS Migration Hub Orchestrator to simplify and accelerate Microsoft SQL Server migrations

This post presents a solution that removes migration barriers and accelerates SQL Server migrations.

Simplify your Microsoft SQL Server high availability deployments

This blog post shows how using Amazon FSx to run SQL Server Always On deployments helps you reduce complexity and cost.

Evaluate downgrading Microsoft SQL Server from Enterprise edition to Standard edition on AWS

This guide is for program or project managers, product owners, database and application administrators, database engineers, operations or infrastructure managers, and database and system architects.

Migrate SQL Server to AWS using distributed availability groups

Microsoft SQL Server Always On availability groups provide a high availability (HA) and disaster recovery (DR) solution for SQL Server.

Amazon RDS support for SQL Server Integration Services

To learn how to deploy your SQL Server Integration Services (SSIS) packages on Amazon RDS, watch this video.

Amazon RDS support for SQL Server Analysis Services

To learn how to deploy your SQL Server Analysis Services (SSAS) models on Amazon RDS, watch this video.

Amazon RDS support for SQL Server Reporting Services

To learn how to deploy your SQL Server Reporting Services (SSRS) reports on Amazon RDS, watch this video.

How do you optimize your Microsoft licensing options on AWS?

AWS offers a range of flexible licensing choices to run your Microsoft workloads on AWS.

Microsoft Licensing on AWS

Here is a guide that discusses optimizing Microsoft licensing on AWS.

Optimize your SQL Server costs by using BYOM on Amazon RDS Custom for SQL Server

This blog post walks you through the step-by-step process to bring your own media and use it to set up Amazon RDS Custom for SQL Server using a CEV.

What are some of the best practices that you can follow post migration?

Here are some of the best practices you can follow after you migrate your workloads.

Best practices for configuring performance parameters for Amazon RDS for SQL Server

This post discusses some parameters that you can tune to enhance database performance.

Post-migration steps and best practices for Amazon RDS for SQL Server

This post talks about some of the post-migration steps and best practices for Amazon RDS for SQL Server.

Best Practices on how to configure Monitoring and Alerts for Amazon RDS for SQL Server: Part1

This post highlights the key metrics and events that you might want to subscribe to for monitoring RDS for SQL Server databases.