The course teaches how to migrate SQL Servers to AWS using the AWS Database Migration Service (DMS). It covers deploying SQL Server on Amazon EC2 or RDS, system sizing, security, and automation best practices. Students will learn migration strategies, backup/restore methods, and tools like CloudEndure Migration and Server Migration Service. The course also explores modernizing SQL Server workloads by moving to open-source and cloud-native AWS databases. The intended audience includes IT professionals, database administrators, and cloud engineers looking to migrate SQL Server workloads to AWS.
Overview
Syllabus
Intro
Why migrate your workloads to AWS?
Options for Deploying SQL Server on AWS
SQL Server Features at a Glance
SQL Server Migration Strategies
Assessment and Planning
Native SQL Server Backup/Restore Migrations
Using the AWS Snow Family
Native EC2W/Hybrid (RDS) SQL Server Log Shipping
Using Transactional Replication
Extending an Availability Group Into AWS
Distributed Availability Group
Always On Availability Group Quick Start
Migrating SQL Server 2008/2008 R2
Migration Tool: CloudEndure Migration
Migration Tool: Server Migration Service
End-of-Support Migration Program (EMP) for Windows
Keep Your Apps Running During The Migration
AWS Schema Conversion Tool
Database Migration Process
Taught by
PASS Data Community Summit
Related Courses
-
Migrating to Cloud SQL from Amazon RDS for MySQL Using Database Migration Service
-
Migrate SQL Server workloads to Azure SQL
-
Migrating to Cloud SQL from Amazon RDS for MySQL Using Database Migration Service
-
Migrating MySQL data to Cloud SQL using Database Migration Service
-
Introduction to AWS Database Migration Service
-
Architect migration, business continuity, and disaster recovery in Azure
