Migrate using Azure SQL migration extension for Azure Data Studio

After you complete the pre-migration tasks, follow the steps below to migrate your on-premises SQL database to Azure SQL Database using the Azure SQL migration extension for Azure Data Studio.

The instructions below are based on migration steps provided by Microsoft.

Note: Azure Data Studio retires in 2026. Instead performing your migration using the Azure SQL migration extension for Azure Data Studio, you also have the option to use Azure CLI or Windows Powershell.

Prerequisites

1. Install the Azure SQL migration extension.

2. Make sure that your Azure subscription is registered for Microsoft.DataMigration.

Migrate your database

3. Open Azure Data Studio.

4. Connect to the on-premises PI Vision SQL Server database that you want to migrate to Azure SQL Database.

5. Right-click the on-premises PI Vision SQL Server database and select Manage.

6. On the Manage page, select Migrate to Azure SQL.

7. Select the Azure SQL Migration tab, then select Migrate to Azure SQL.

8. Select Next to begin the migration session.

9. On Step 1: Databases for assessment, select the PI Vision database that you want to migrate, then select Next.

   The Assessment in Progress message appears.

10. On Step 2: Assessment summary and SKU recommendations, review the information after the assessment is complete to ensure there are no issues, then select Next.

11. On Step 3: Target platform & assessment results, in the Select target type field select Azure SQL Database, then select Next.

12. On Step 4: Azure SQL Target, provide details about your Azure account:

    1. Enter and link your Azure account.

    2. Enter the subscription information, location, and Resource group for your database.

    3. Select your Azure SQL Instance.

    4. Enter your username and password of your target Azure SQL database, then select Connect.

    5. If needed, select the Azure SQL PI Vision database as the target database

    6. Select Next.

13. On Step 5: Azure Database Migration Service, enter or select the following information:

    7. Your Azure subscription name & ID

    8. Name of your resource group

    9. Select a pre-configured Azure Database Migration Service or select the Create new link to create a new service.

14. If an Integration Runtime Agent is already installed on the machine, it is listed at the bottom of the screen. If one is not installed, perform the following steps:

    10. Select the Configure Integration Runtime link.

    11. Select self-hosted integration runtime on my local machine.

    12. Select Execute Script.

    13. Once the script completes, select Next.

15. On Step 6: Data source configuration, provide the following information:

    14. The credentials for connecting to the local on-prem SQL Server.

    15. Select all tables on the Available on Target tab.

    16. Select Update, then select Run Validation.

    17. After the validation process has been completed and passed, select Done.

    18. Select Next.

16. Review all the information on the screen, then select Start Migration.

    After the migration is successfully completed, your on-premises PI Vision SQL Server database is now available in Azure SQL Database.