Migrate using Windows PowerShell

After you complete the pre-migration tasks, follow the steps below to migrate your on-premises SQL database to Azure SQL Database using Windows PowerShell.

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

1. Run PowerShell in Administrative mode.

2. Install Azure PowerShell.

3. Connect to Azure within the PowerShell session following the Microsoft instructions for the Connect-AzAccount command.

4. Set the Azure subscription to use in this session following the Microsoft instructions for the Set-AzContext command.

5. If you do not have a pre-configured database migration service set up and a 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 instructions for the New-AzDataMigrationSqlService command.

   3. Get the authentication key for the self-hosted integration runtime following the Microsoft instructions for the Get-AzDataMigrationSqlServiceAuthKey command.

   4. Register the database migration service following the Microsoft instructions for the Register-AzDataMigrationIntegrationRuntime command.

6. Create the database migration to the new Azure SQL Database following the Microsoft instructions for the New-AzDataMigrationToSqlDb command.