Introduction

  • 2 minutes

SQL Server on Azure Virtual Machine allows you to run complete SQL Server editions without the burden of managing on-premises hardware. Azure offers a large gallery of virtual machine (VM) images allowing you to deploy a server quickly with the exact version, edition, and operating system you need. This Infrastructure as a Service (IaaS) approach has benefits, and considerations that you need to take into account when taking this migration path.

You may have specific requirements that are better suited for SQL Server on Azure Virtual Machines rather than Azure SQL Managed Instance in the following scenarios:

  • You need direct access to the operating system or file system, such as installing non-Microsoft or custom agents on the same virtual machine alongside SQL Server.
  • You heavily rely on features that aren't yet supported, such as FileStream/FileTable, PolyBase, and cross-instance transactions.
  • Your business requires staying at a particular version of SQL Server.
  • Your compute requirements are lower than what a managed instance offers, and database consolidation isn't an option.

Use case scenario

Throughout this module, we're using an example scenario to explain key data migration concepts.

You work as a senior database administrator at a global retail company. You collaborate with consultants and architects to initiate a data platform modernization project that meets the organization's technical and business requirements.

The organization has a large number of different databases that underpin business-critical functions such as Customer Relationship Management (CRM), stock management, distribution, and human resources. The company runs many on-premises databases on different versions across multiple servers.

Your main responsibility is to identify what is needed and ultimately migrate many databases running different versions of SQL Server.

In this module, you learn how to migrate SQL Server workloads to run on Azure Virtual Machine. You explore the various ways you can migrate your SQL Server workloads both offline and online. After you migrate your workload, you'll complete some post migration tasks. These tasks ensure the migrated database performance isn't affected.

By the end of this module, you're able to plan and execute a migration from on-premises SQL Server to Azure Virtual Machine.