From the course: AWS Certified Database – Specialty (DBS-C01) Cert Prep: 3 Migration and Management
Join today to access over 22,600 courses taught by industry experts.
Executing data migration - Amazon Web Services (AWS) Tutorial
From the course: AWS Certified Database – Specialty (DBS-C01) Cert Prep: 3 Migration and Management
Executing data migration
- Okay, we have a scenario here that's actually rather common. We actually have an EC2 instance running Windows Server with Microsoft SQL Server on it, providing a database in that instance. So it's an instance based database running in the AWS cloud. But we want to move that over to a managed database. We've done some calculations, we've figured out it's going to be less expensive for us to run it as a managed database. So we want to move in a new direction. But in order to do that, we need to be able to get the data out of our current EC2 instance and into the managed database system. So let's take a look at what we have currently on the instance. So here we're looking at our EC2 instance. You can see based on this little bar here at the top that I'm connected with remote desktop into the instance. I'm running the Microsoft SQL Server Management Studio. And you can see that I have several different databases if you…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.