Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
Permalink
live
Switch branches/tags

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?
Go to file
 
 
Cannot retrieve contributors at this time
title description author ms.author ms.reviewer ms.date ms.service ms.workload ms.topic
Azure SQL migration extension for Azure Data Studio
This article describes how you can migrate your data using the Azure SQL migration extension with Azure Data Studio.
croblesm
roblescarlos
09/01/2021
azure-data-studio
data-services
conceptual

Azure SQL migration extension for Azure Data Studio

[!INCLUDE database-migration-services-ads]

This article describes installing the Azure SQL migration extension through Azure Data Studio.

Prerequisites

If you don't have an Azure subscription, create a free Azure account before you begin.

The following prerequisites are also required to install this extension:

Install the Azure SQL migration extension

Follow the steps below to install the Azure SQL migration extension in Azure Data Studio.

  1. Open the extensions manager in Azure Data Studio. You can either select the extensions icon or select Extensions in the View menu.

    :::image type="content" source="media/azure-sql-migration-extension/extension-icon.png" alt-text="Extension icon":::

  2. Type in Azure SQL Migration in the search bar.

  3. Select the Azure SQL Migration extension and view its details.

  4. Select Install.

    :::image type="content" source="media/azure-sql-migration-extension/azure-sql-migration-extension-market-place.png" alt-text="Azure SQl Migration extension from market place":::

  5. You can see the Azure SQL migration extension in the extension list once installed.

    :::image type="content" source="media/azure-sql-migration-extension/azure-sql-migration-icon.png" alt-text="Azure SQL migration extension":::

  6. You can connect to the SQL Server instance in Azure Data Studio. Right-click the instance name and select Manage to see the dashboard and the Azure SQL Migration extension landing page.

    :::image type="content" source="media/azure-sql-migration-extension/azure-sql-migration-extension-landing-page.png" alt-text="Landing page":::

Set up auto update for the extension

[!INCLUDE auto-update-extension]

Features

Azure SQL target readiness assessment and database migrations

The Azure SQL migration extension supports assessment and generates Azure recommendations (Preview) and database migrations for the following Azure SQL targets.

  • SQL Server on Azure Virtual Machines
  • Azure SQL Managed Instance
  • Azure SQL Database (Preview)

Migration modes

The following migration modes are supported for the corresponding Azure SQL targets.

  • Online - The source SQL Server database is available for reading and writing activity, while database backups are continuously restored on target Azure SQL. Application downtime is limited to the duration of the cutover at the end of migration.
  • Offline - The source database can't be used for writing activity while backup files are restored on the target Azure SQL database (Preview). Application downtime persists from the start until the completion of the migration process.

Support matrix

Azure SQL target Migration mode
Azure SQL Managed Instance Online / Offline
SQL Server on Azure Virtual Machine Online / Offline
Azure SQL Database (Preview) Offline

[!TIP] For information on pre-requisites, features and migration workflow, see Migration using Azure Data Studio

Get help from Microsoft support

You can raise a support request to get Microsoft support assistance if you encounter issues or errors with your database migrations using the Azure SQL Migration extension.

Click on the New support request button in the upper section of the extension. It will automatically take you to the Azure portal, where you can fill in the details and then submit a support request. :::image type="content" source="media/azure-sql-migration-extension/extension-support.png" alt-text="Get help from Microsoft support for the extension":::

You can submit ideas/suggestions for improvement, and other feedback, including bugs, in the Azure Community forum — Azure Database Migration Service.

[!NOTE] You can also use the Feedback button if you have any suggestions or feedback to improve the extension.

Next steps