| author | markingmyname |
|---|---|
| ms.author | maghan |
| ms.service | sql-database |
| ms.topic | include |
| ms.date | 07/30/2021 |
You can use the Azure SQL Migration extension in Azure Data Studio to migrate SQL Server databases to either Azure SQL Managed Instance (Platform-as-a-Service) or to SQL Server on Azure Virtual Machines (Infrastructure-as-a-Service).
The new Azure SQL Migration extension in Azure Data Studio brings together a simplified assessment and migration experience that delivers the following capabilities:
- A responsive user interface that provides an easy-to-navigate step-by-step wizard to deliver an integrated assessment and migration experience.
- An enhanced assessment engine that can assess SQL Server instances and identify databases that are ready for migration to Azure SQL Managed Instance or SQL Server on Azure Virtual Machines.
- A reliable Azure service powered by Azure Database Migration service that orchestrates data movement activities to deliver a seamless migration experience with minimal downtime.
- The ability to run migrations in either online (for migrations that require minimal downtime) or offline (for migrations where downtime persists through the duration of the migration) modes to suit your business requirements.
- The flexibility to install self hosted integration runtime to provide your own compute for access to source SQL Server and backups in your on-premises environment.
To learn more about the concepts for migrating databases using the Azure SQL Migration extension in Azure Data Studio, see Database migrations using Azure Data Studio.