Migrate using Azure CLI

After you complete the pre-migration tasks, follow the steps below to migrate your on-premises SQL database to Azure SQL Database using Azure Command Line Interface (CLI) .

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

1. Open PowerShell in Administrative mode.

2. Download and install the Azure CLI utility. Refer to Azure Command-Line Interface (CLI) for install instructions.

3. Connect to Azure within this PowerShell session following the Microsoft documentation for the az-login command.

4. Set the Azure subscription that you want to use following the Authenticate to Azure using Azure CLI instructions.

5. If you do not have a pre-configured database migration service and self-hosted Integration Runtime agent, enter the following commands to configure the service and agent:

   1. Download the Microsoft Integration Runtime.

   2. Create the Database Migration Service following the Microsoft documentation for the az datamigration sql-service create command.

   3. Get the authentication key for the self-hosted integration runtime following the Microsoft instructions for the az datamigration sql-service list-auth-key command.

   4. Register the database migration service following the Microsoft instructions for the az datamigration register-integration-runtime command.

6. Create the database migration to the new Azure SQL Database following the Microsoft instructions for the az datamigration sql-db create command.