Migrating SQL Servers to AWS

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Discover how to migrate SQL Server databases to Amazon Web Services (AWS) in this 56-minute conference talk from PASS Data Community Summit. Learn about the AWS Database Migration Service (DMS) and explore options for deploying SQL Server on Amazon EC2 or Amazon RDS. Gain insights into best practices for system sizing, configuration, security, and automation of SQL Server workloads in the cloud. Explore various migration strategies, including native backup/restore, log shipping, transactional replication, and Availability Groups. Understand assessment and planning processes, and learn about migration tools like CloudEndure Migration and Server Migration Service. Discover how to keep applications running during migration and explore options for modernizing SQL Server workloads using open-source and cloud-native AWS databases.

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