title: PowerShell example import BACPAC file Azure SQL database | Microsoft Docs description: Azure PowerShell example script to import a BACPAC file into a SQL database services: sql-database ms.service: sql-database ms.subservice: data-movement ms.custom: load & move data ms.devlang: PowerShell ms.topic: sample author: CarlRabeler ms.author: carlrab ms.reviewer: manager: craigg ms.date: 09/07/2018
This PowerShell script example imports a database from a BACPAC file into an Azure SQL database.
[!INCLUDE quickstarts-free-trial-note] [!INCLUDE cloud-shell-powershell.md]
If you choose to install and use the PowerShell locally, this tutorial requires the Azure PowerShell module version 5.7.0 or later. Run Get-Module -ListAvailable AzureRM to find the version. If you need to upgrade, see Install Azure PowerShell module. If you are running PowerShell locally, you also need to run Connect-AzureRmAccount to create a connection with Azure.
[!code-powershell-interactivemain]
After the script sample has been run, the following command can be used to remove the resource group and all resources associated with it.
Remove-AzureRmResourceGroup -ResourceGroupName $resourcegroupnameThis script uses the following commands. Each command in the table links to command specific documentation.
| Command | Notes |
|---|---|
| New-AzureRmResourceGroup | Creates a resource group in which all resources are stored. |
| New-AzureRmSqlServer | Creates a logical server that hosts the SQL Database. |
| New-AzureRmSqlServerFirewallRule | Creates a firewall rule to allow access to all SQL Databases on the server from the entered IP address range. |
| New-AzureRmSqlDatabaseImport | Imports a BACPAC file and create a new database on the server. |
| Remove-AzureRmResourceGroup | Deletes a resource group including all nested resources. |
For more information on the Azure PowerShell, see Azure PowerShell documentation.
Additional SQL Database PowerShell script samples can be found in the Azure SQL Database PowerShell scripts.