Document Details
Template Tutorial Deploy Sql Extensions Bacpac
❌
This page contains Windows bias
About This Page
This page is part of the Azure documentation. It contains code examples and configuration instructions for working with Azure services.
Bias Analysis
Bias Types:
⚠️
powershell_heavy
⚠️
windows_first
⚠️
missing_linux_example
Summary:
The documentation demonstrates a strong Windows bias by providing only PowerShell scripts for preparing and deploying the BACPAC file, and by instructing users to select PowerShell in Azure Cloud Shell. There are no equivalent Bash or Linux-native examples, and the workflow assumes familiarity with Windows-centric tools and patterns. While there is a brief mention that Azure Cloud Shell can run PowerShell or Bash, all practical examples and screenshots use PowerShell exclusively.
Recommendations:
- Provide equivalent Bash scripts for all PowerShell examples, especially for preparing the BACPAC file and deploying the ARM template. Ensure these scripts work in Azure Cloud Shell (Bash) and on Linux/macOS terminals.
- When instructing users to select a shell in Azure Cloud Shell, present both PowerShell and Bash as equal options, or default to Bash for cross-platform parity.
- Include screenshots and instructions for both PowerShell and Bash environments where relevant.
- Explicitly mention that all steps can be performed on Linux/macOS, and provide any necessary platform-specific notes (e.g., file paths, command differences).
- Where third-party tools are referenced (e.g., openssl), clarify their availability on both Windows and Linux, and provide installation guidance if needed.
Create pull request
Scan History
| Date | Scan ID | Status | Bias Status |
|---|---|---|---|
| 2025-07-12 23:44 | #41 | in_progress | ❌ Biased |
| 2025-07-12 00:58 | #8 | cancelled | ✅ Clean |
| 2025-07-10 05:06 | #7 | processing | ✅ Clean |
Flagged Code Snippets
The following example shows the updated template:
:::image type="content" source="media/template-tutorial-deploy-sql-extensions-bacpac/resource-manager-tutorial-deploy-sql-extensions-bacpac.png" alt-text="Screenshot of the template with SQL Database extension.":::
To understand the resource definition, see the API version's [SQL Database extension reference](/azure/templates/microsoft.sql/servers/databases/extensions). The following are some important elements:
- `dependsOn`: The extension resource must be created after the database has been created.
- `storageKeyType`: Specify the type of the storage key to use. The value can be either `StorageAccessKey` or `SharedAccessKey`. Use `StorageAccessKey` in this tutorial.
- `storageKey`: Specify the key for the storage account where the BACPAC file is stored. If the storage key type is `SharedAccessKey`, it must be preceded with a "?".
- `storageUri`: Specify the URL of the BACPAC file stored in a storage account.
- `administratorLogin`: The SQL administrator's account name.
- `administratorLoginPassword`: The SQL administrator's password. To use a generated password, see [Prerequisites](#prerequisites).
The following example shows the completed template:
[!code-json[](~/resourcemanager-templates/tutorial-sql-extension/azuredeploy2.json?range=1-106&highlight=38-49,62-76,86-103)]
## Deploy the template
Use the project name and location that were used when you prepared the BACPAC file. That puts all resources in the same resource group, which is helpful when you delete resources.
1. Sign in to [Cloud Shell](https://shell.azure.com).
1. Select **PowerShell** from the upper left corner.
:::image type="content" source="media/template-tutorial-deploy-sql-extensions-bacpac/cloud-shell-select.png" alt-text="Screenshot of Azure Cloud Shell in PowerShell with the option to upload a file.":::
1. Select **Upload/Download files** and upload your _azuredeploy.json_ file.
1. To deploy the template, copy and paste the following script into the shell window.
1. Select **Open** to open the file.
There are two resources defined in the template:
- `Microsoft.Sql/servers`. See the [template reference](/azure/templates/microsoft.sql/servers).
- `Microsoft.SQL.servers/databases`. See the [template reference](/azure/templates/microsoft.sql/servers/databases).
It's helpful to get some basic understanding of the template before you customize it.
1. Select **File** > **Save As** to save a copy of the file to your local computer with the name _azuredeploy.json_.
## Edit the template
1. Add two parameters at the end of the `parameters` section to set the storage account key and the BACPAC URL.