Skip to content

Latest commit

 

History

History
86 lines (56 loc) · 6.07 KB

dotnet-howto-migrate-sql.md

File metadata and controls

86 lines (56 loc) · 6.07 KB
title description ms.date author ms.author ms.service ms.topic
Migrate a SQL Server database to Azure
Learn how to migrate a SQL Server database from on-premises SQL Server to Azure.
11/15/2017
CamSoper
casoper
sql-database
conceptual

Migrate a SQL Server database to Azure

This short article provides a brief outline of two options for migrating a SQL Server database to Azure.

Azure has two primary options for migrating a production SQL Server database:

  1. SQL Server on Azure VMs: A SQL Server instance installed and hosted on a Windows Virtual Machine running in Azure, also known as Infrastructure as a Service (IaaS).
  2. Azure SQL Database: A fully managed SQL database Azure service, also known as Platform as a Service (PaaS).

Both come with pros and cons that you will need to evaluate before migrating.

Get started

The following migration guides will be useful, depending on which service you use:

Additionally, the following links to conceptual content will help you understand VMs better:

And the following links will help you understand Azure SQL Database better:

Choosing IaaS or PaaS

When evaluating where to migrate your database, you should determine if IaaS or PaaS is more appropriate for you.

You should choose SQL Server in Azure VMs if:

  • You are looking to "lift and shift" your database and applications with minimal to no changes.
  • You prefer having full control over your database server and the VM it runs on.
  • You already have SQL Server and Windows Server licenses that you intend to use.

You should choose Azure SQL Database if:

  • You are looking to modernize your applications and are migrating to use other PaaS services in Azure.
  • You do not wish to manage your database server and the VM it runs on.
  • You do not have SQL Server or Windows Server licenses, or you intend to let licenses you have expire.

The following table describes differences between each service based on a set of scenarios.

Scenario SQL Server in Azure VMs Azure SQL Database
Migration Requires minimal changes to your database. May require changes to your database if you use features unavailable in Azure SQL, as determined by the Data Migration Assistant, or if you have other dependencies such as locally installed executables.
Managing availability, recovery, and upgrades Availability and recovery is configured manually. Upgrades can be automated with VM Scale Sets. Automatically managed for you.
Underlying OS configuration Manual configuration. Automatically managed for you.
Managing database size Supports up to 64TB of storage per SQL Server instance. Supports 4TB of storage before needing a horizontal partition.
Managing costs You must manage SQL Server license costs, Windows Server license costs, and VM costs (based on cores, RAM, and storage). You must manage service costs (based on eDTUs or DTUs, storage, and number of databases if using an elastic pool). You must also manage the cost of any SLA.

To learn more about the differences between the two, read Choose a cloud SQL Server option: Azure SQL Database or SQL Server on Azure VMs.

FAQ

  • Can I still use tools such as SQL Server Management Studio and SQL Server Reporting Services (SSRS) with SQL Server in Azure VMs or Azure SQL Database?

    Yes! All Microsoft SQL tooling works with both services. SSRS is not part of Azure SQL Database, though, and it's recommended that you run it in an Azure VM and then point it to your database instance.

  • I want to go PaaS but I'm not sure if my database is compatible. Are there tools to help?

    Yes. The Data Migration Assistant is a tool that is used as a part of migrating to Azure SQL Database. The Azure Database Migration Service is a preview service which you can use for either IaaS or PaaS.

  • Can I estimate costs?

    Yes. The Azure Pricing Calculator can be used for estimating costs for all Azure services, including VMs and database services.

Next steps

[!div class="nextstepaction"] Choose the right Azure hosting option