Migrating SQL Server databases to the cloud is a critical part of a cloud journey and requires planning and architectural considerations. In this session, we cover best practices and guidelines in migrating and/or architecting a hybrid SQL Server architecture on AWS. We compare and contrast various migration methods, including SQL export, backup and restore, and using AWS Database Migration Service (AWS DMS). We also provide guidance on how to migrate products that have approached their end of life, such as SQL Server 2008.

Learning Objectives:
– Understand Amazon RDS for SQL Server capabilities
– Review various migration methods for SQL server into AWS
– Learn how to configure AWS DMS and SCT in migrating databases to AWS

Amazon RDS is a mature Database as a Service offering from AWS. This screencast will cover the setup and configuration of a MySQL database and how to import data.

AWS Database Migration Service helps you migrate databases to AWS quickly and securely. The source database remains fully operational during the migration, minimizing downtime to applications that rely on the database. The AWS Database Migration Service can migrate your data to and from most widely used commercial and open-source databases.

AWS Database Migration Service supports homogeneous migrations such as Oracle to Oracle, as well as heterogeneous migrations between different database platforms, such as Oracle or Microsoft SQL Server to Amazon Aurora. With AWS Database Migration Service, you can continuously replicate your data with high availability and consolidate databases into a petabyte-scale data warehouse by streaming data to Amazon Redshift and Amazon S3. Learn more about the supported source and target databases.

When migrating databases to Amazon Aurora, Amazon Redshift, Amazon DynamoDB or Amazon DocumentDB (with MongoDB compatibility) you can use DMS free for six months.