Azure SQL Database managed instance

A managed instance in Azure SQL Database is a fully managed SQL Server Database Engine Instance hosted in Azure cloud. This is the best PaaS option for migrating your SQL Server database to the cloud. Learn how to create and use Managed Instance with our quickstarts, tutorials, and samples.

New and preview features

We are continuously improving managed instance with new features:

5-Minute Quickstarts

Managed instance enables you to easily perform basic management tasks using the Azure portal, Azure CLI, and Azure PowerShell. Learn how to perform basic management tasks using the following quickstart samples:

The Azure portalThe Azure portalAzure CLIAzure CLIPowerShellPowerShellAzure Resource Manager templateAzure Resource Manager template
Create a new Instance
Modify the Instance
Configure Azure network environment
Point in time restore
Restore database to another instance
Restore dropped database
Geo-Restore database
Set public IP endpoint

Step-by-Step tutorials and learning materials

Learn how to create, manage, and use managed instances.

  1. Learn how to quickly get started with managed instance using our quickstart guides.
  2. Learn about hardware characteristics and limitations, Transact-SQL language differences, and Transact-SQL, PowerShell, Azure CLI API for configuring managed instance.
  3. Configure Azure VNet where the managed instance will be deployed.
  4. Validate that your existing Azure VNet can be used to deploy managed instances.
  5. Connect to your instance using Public IP endpoint, Azure Virtual Machine or Point-to-site connection, or Applications.
  6. Verify that your database can be migrated using Data Migration Assistant or Database Experimentation Assistant.
  7. Bring your databases to managed instance using Native restore or Data Migration Service.
  8. Move your SSIS packages to Azure Data Factory, SSAS tabular models to Azure Analysis Service, and SSRS reports to PowerBI Premium.
  9. Learn about the storage layer in General Purpose tier and apply storage performance best practices and considerations for General Purpose service tier.
  10. Find the best practices and recommendations for securing your instance.
  11. Find more How-to guides that can help you configure your managed instance.

Reference