Introduction to Amazon Relational Database Service (RDS) - SQL Server

Introduction to Amazon Relational Database Service (RDS) - SQL Server

1 hour 10 minutes 1 Credit

SPL-145 Version 2.0.6

© 2019 Amazon Web Services, Inc. and its affiliates. All rights reserved. This work may not be reproduced or redistributed, in whole or in part, without prior written permission from Amazon Web Services, Inc. Commercial copying, lending, or selling is prohibited.

Errors or corrections? Email us at

Other questions? Contact us at


This lab provides an overview of using Amazon Relational Database Service (Amazon RDS) for SQL Server.

Topics covered

By the end of this lab, you will be able to:

  • Create an Amazon Relational Database Service (Amazon RDS) SQL Server instance
  • Connect to the RDS instance using Microsoft SQL Server Management Studio
  • Export data from a local database to an Amazon RDS SQL Server database

Mac Users: Download Remote Desktop Client Software

If you are running Windows on your local machine, you can use Remote Desktop Connection to access your Amazon EC2 instance.

If you are on a Mac, you will require Microsoft Remote Desktop (with the red icon):

Microsoft Remote Desktop

Mac users can download Microsoft Remote Desktop from the Mac App Store.

If you do not have access to the Mac App Store, you can use CoRD for Mac, but please note that the instructions for this lab assume you are using Microsoft Remote Desktop.

Amazon Relational Database Service (RDS)

Amazon Relational Database Service (Amazon RDS) is a web service that makes it easy to setup, operate, and scale relational databases in the cloud. It allows you to create and use MySQL, MariaDB, PostgreSQL, Oracle or SQL Server databases. This means the code, applications, and tools you already use today with your existing databases can be used with Amazon RDS.

With Amazon RDS for SQL Server, you can deploy multiple editions of SQL Server (2008 R2, 2012, 2014 and 2016) including Express, Web, Standard and Enterprise in minutes with cost-efficient and re-sizable compute capacity. Amazon RDS frees you up to focus on application development because it simplifies many database administration tasks including taking backups, software patching, monitoring, hardware scaling, and designing for high availability.

Join Qwiklabs to read the rest of this lab...and more!

  • Get temporary access to the Amazon Web Services Console.
  • Over 200 labs from beginner to advanced levels.
  • Bite-sized so you can learn at your own pace.
Join to Start This Lab