Migrating Your Existing SQL Server Estate to Amazon's RDS

Learn Real World Techniques For Moving Your Production SQL Servers To Amazon Web Services (AWS) RDS
4.4 (33 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
546 students enrolled
Take This Course
  • Lectures 34
  • Length 1.5 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 6/2015 English

Course Description

This course focuses on moving SQL Server Databases to Amazon's RDS SERVICE. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

Before WE get started I would like to share MY excitement on co-authoring my first course. I will be working with noted cloud expert Ryan Kroonenburg. This is the first course I'm co-authoring and couldn't be more excited about working with author and AWS Could Architect Ryan Kroonenburg. Ryan's been teaching AWS centric courses on Udemy for quite some time and his courses are the most highly rated AWS courses available.

HOW is this course different from my course titled How To Become a SQL Server Cloud Architect on AWS? This course is more focused on MIGRATING your on premise databases to RDS. We will be solely focused on RDS and walk through several migration and post migration STRATEGIES.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

ENROLL NOW!!. Let's Get Started

What are the requirements?

  • Every Student Will Need An AWS Account. We Will Walk Through Setting One Up At The Start Of The Course
  • A Solid Foundation With SQL Server Would Be Very Beneficial.
  • A Basic Understanding Of Amazon's AWS Service Would Also Help.

What am I going to get from this course?

  • Move Your Existing SQL Server Databases To Amazon's Relational Database Service.
  • Learn The Benefits To Amazon's Relational Database Service
  • Design Real World Solutions For Moving SQL Server To RDS

Who is the target audience?

  • If You Are Responsible For Moving Databases To RDS This Course Is For You.
  • Any SQL Server DBA or Windows Administrator Who Wants To Learn How To Maximize RDS Should Take This Course.
  • Any AWS Could Architect Who Is Responsible For Managing Their AWS Estate.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: An Introduction To SQL Server on RDS. Amazon's AWS Is The "New Normal"

Welcome to Migrating You Existing SQL Server Estate to RDS. Let's talk about what's in the course, who should take it and what you'll take away when you've finished.

All of our courses are real world approaches to working with AWS. This one is no different. You'll be able to take what you've learned and immediately apply to real world environments.

Let's Get Started!!


A little about Mike, the new RDS guy.


Ryan talks about the certification process and some applications to further the learning process.


Please head over and sign up. This is a great place for questions specific to the course and questions that may be outside of the scope of the current course but you simply have to know.


We make every attempt to ensure the course is up to date and without error as possible. However, some changes may be out of our control. We are constantly monitoring AWS for changes to their services.


This lecture is specific to Amazon's cloud offering. Each cloud service provider has their own unique nuances and we talk about Amazon's here.

AWS stands for Amazon Web Services and we overview it here.


AWS stands for Amazon Web Services. It's a vast offering of services you can mix and match to suite your needs. This course will focus mostly on RDS or the "Relational Database Service."

We are going to focus much of this course on how we can move our on-premise database to RDS. There are a lot more limitations and variables with cloud architecture and we will cover them here.


Location of scripts and all of the course content. Please take minute to download the course content and save it to a folder you'll be able to easily access. The downloadable is included as a zip file.


Every IT sector has its own vernacular. The could is no different. In this section we'll cover a few terms that are used often.


Let's wrap up what we've covered in this section. The basics will often build the foundation we need to understand the nuances later.

Section 1 Quiz
10 questions
Section 2: Let's Talk About What We Will Need For This Course.

You won't need many items to take this course. Even better, all the items you do need are free.


Script libraries allow us easy access to important files we need to troubleshoot critical issues.

They are also good for performance tuning. All the tier one SQL Server DBAs I know use a script library. I've included some tips and tricks on creating one.


A look at what we've covered in this section.

Section 2 Quiz
10 questions
Section 3: RDS - An Overview

How SQL Server and RDS behave. Amazon's OLTP service was designed specifically for relational databases like SQL Server.


This is how we benchmark the computing power we need. Recall the big three? (IO, Memory and CPU) These instances classes cover two of them. (memory and CPU)


This is easily one of the most confusing areas in moving anything to the cloud. Ryan discusses an approach to benchmarking your costs.


When we provision an instance we create an instance. Another term is to spin up an instance. In this lecture we create our first instance.


Let's wrap up what we've covered in this course.

Section 3 Quiz.
10 questions
Section 4: Migrations - The Complete Guide

In this lecture we highlight a few important items we need to take into account before we dive head first into moving our estate to the cloud.

These are easily committed to memory once you've migrated your first instance to the RDS.


I'm using the term native here to mean that we need no third party tools to move schema and cloud to RDS. This approach will serve you well for small databases.


We have the option to script data and schema together or separately. Some DBAs like to see the schema alone prior to scripting or moving the data.


In this lecture we are moving a larger more complex database to RDS. It's only complex compared to our initial example but it does add keys and other objects that need to be scripted.


In this lecture we script our the schema separately and then use a component of SSIS to push our data to RDS.


I'm with you. This course is focused on AWS why would we use a tool for Azure? Well, it might have been written for Azure but it works flawlessly with RDS.

Let's take a look at how this tool brute forces our databases to RDS. This might not always be the best choice but it's a great first swipe at testing what we can move to RDS without major complications.


Most database will have objects that aren't cloud compatible and we will have to sift through them before the application goes live in RDS.


A quick review of what we covered in the section.

Questions and Answers. *Audio*
Section 4 Quiz
10 questions
Section 5: Post Migration Strategies

Logins and permission are *NOT* moved automatically. You must move them manually. Thankful, this script provided by Microsoft will easily move the logins.


The performance monitor in the cloud. Another component of RDS you'll be using often. It's really well integreated into the instance.


You run out of cpu or memory and you have to scale up. It's very easy to do but it does incurr an outage.


SQL Server Agent is included with every version except for express. Let's walk through a simple example and add a stats rebuild job.


Let's wrap up what we've covered.

Section 5 Quiz
10 questions
Section 6: SQL Server Courses Coming Soon

Let's wrap up this course. Thanks for taking it.

SQL Server RDS Master Classes On The Horizon.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Mike West, SQL Server Evangelist

I've been a production SQL Server DBA most of my career.

I've worked with databases for over two decades. I've worked for or consulted with over 50 different companies as a full time employee or consultant. Fortune 500 as well as several small to mid-size companies. Some include: Georgia Pacific, SunTrust, Reed Construction Data, Building Systems Design, NetCertainty, The Home Shopping Network, SwingVote, Atlanta Gas and Light and Northrup Grumman.

Experience, education and passion

I learn something almost every day. I work with insanely smart people. I'm a voracious learner of all things SQL Server and I'm passionate about sharing what I've learned. My area of concentration is performance tuning. SQL Server is like an exotic sports car, it will run just fine in anyone's hands but put it in the hands of skilled tuner and it will perform like a race car.


Certifications are like college degrees, they are a great starting points to begin learning. I'm a Microsoft Certified Database Administrator (MCDBA), Microsoft Certified System Engineer (MCSE) and Microsoft Certified Trainer (MCT).


Born in Ohio, raised and educated in Pennsylvania, I currently reside in Atlanta with my wife and two children.

Instructor Biography

Ryan Kroonenburg, Solutions Architect

I am the founder of A Cloud Guru and an Amazon Web Services community hero. I hold every associate certification and I am a certified AWS Solutions Architect Professional. I am ex-Rackspace, ex-Sungard & ex-Smart421. I have been working in the Cloud space since it's very inception.

I am not just another I.T. trainer. I teach Cloud because I know it. Inside and out. I've worked as a systems administrator, developer, solutions architect & managing director/general manager for some of the biggest companies in cloud. My courses are not just some other IT training course, delivered by some IT trainer. My background is very hands on. I live eat and breath cloud. I will teach you everything that I know. If you want some boring, high level and theoretical cloud training platform, then my courses are not for you! You will love my courses because of my explain it like I'm 5 approach.

I have 17 years experience in IT in total and I am fluent across both Windows and Linux platforms. My courses are all cloud based and will be aimed to accommodate both absolute beginners, as well professionals. I always start with the basics and by the end of my courses you will be proficient as a Cloud Guru. Please add me on Linkedin or follow me on Twitter!

Get ready to become A Cloud Guru!

Instructor Biography

Samuel Kroonenburg, Startup Founder & Software Engineer

Sam Kroonenburg is the co-founder of Appfail - a web startup with thousands of customers worldwide, including some of the biggest brands in the world. Sam has also built some of the largest software products in the world, having worked extensively as an engineer across the world (USA, UK, Norway and Australia) at companies like Microsoft. Sam helped to build Windows Vista and Windows 7.

Ready to start learning?
Take This Course