View on GitHub

SqlBuildManager

SQL Build Manager is an all-in-one database management tool to easily update your fleet SQL Server databases - from one to tens of thousands.

Template Scripts reference (LEGACY)

⚠️ NOTE: The scripts in this directory have been superseded by the Azure Developer CLI (azd) deployment workflow. All scripts here are prefixed with xxOBSOLETE_ and are retained for historical reference only.

For current resource provisioning, use azd up from the repository root. See Setting up an Azure Environment for full details.

Active helper scripts can be found in the parent scripts/ directory (e.g., scripts/create_batch_settingsfiles_mi_only.ps1, scripts/create_aci_settingsfile_mi_only.ps1, etc.).

Legacy: create_azure_resources.ps1

This is a one-stop script for creating all of the resources you will need to leverage SQL Build Manager. Uses the azuredeploy_main.bicep file which will leverage the bicep modules in the Modules folder as needed per the parameters passed in.

It will always create these Azure resources:

Virtual Network and 4 Subnets
Storage Account
Event Hub Namespace and Event Hub
Service Bus Namespace and Topic
Key Vault
User Assigned Managed Identity with RBAC Assignments
Current User RBAC Assignments

If you specify a -testDatabaseCount value of greater than 0 (zero), it will create:

2 Azure SQL Servers
Designated number of databases per server

With the default -deploy value of All, it will also deploy:

Azure Batch Account
AKS Cluster Azure Container Registry
Azure Container App Environment
The settings files needed for external tests of Azure Batch, AKS, Azure Container Apps and ACI
Run an Azure Container Registry Build to create the Docker image for SqlBuildManager
Build the code (both Windows and Linux targets) and publish the packages to the Azure Batch account

Otherwise you can specify a -deploy value of Batch, AKS, ContainerApp or ACI (or any combination) to deploy only the resources needed for that environment along with the test settings files and builds.

Legacy: create_all_settingsfiles_fromprefix.ps1

A helper script that will create the settings files for all of the deployment types. If you run create_azure_resources.ps1, it will already create the settings files for you.

Subfolder scripts

Each subfolder has scripts and to individually create resources and settings files for those resources.