From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Implement a migration between Azure SQL services

Implement a migration between Azure SQL services

From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Implement a migration between Azure SQL services

“

- Welcome back. This is Lesson 3.9, Implement a migration between Azure SQL services. When we talk about migrating or a migration between Azure SQL services, it refers to going from one Azure SQL service to another, such as taking a database from an Azure VM to Azure SQL Database. So when we talk about these scenarios, we have several options, you have several options. Let's begin with infrastructures as service to platforms as a service, where I'm taking a database in an Azure VM and migrating it to either Azure SQL Database or Azure SQL Managed Instance. So first and foremost are the tried and true Azure Database Migration Services and Azure Migrate. We've talked about both of these before in pretty good detail, but it does provide the analysis and the assessment of what it's going to take to go from Azure infrastructure as a service to platform as a service. However, depending on the size of the database, you could do a backpack. In SQL Server Management Studio within the virtual…

Contents