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.

SQL Build Manager Change Log

Version 15.6.1

Version 15.6.0

Version 15.5.0

Version 15.4.2

Version 15.4.1

Version 15.4.0

Version 15.3.0

Consolidated updates in Version 15+ NEW: Removing beta tag as the new AKS Workload Identity implementation is now GA. This replaces of AAD Pod Identity and is a breaking change from any previous Kubernetes deployments. To understand how to configure your cluster, review the steps in the create_aks_cluster.ps1 script.

New & Updated Commands:

New Options:

New Configuration:

Bug Fixes & Improvements:

Platform updates:

Version 15.2.2-beta

Version 15.2.1-beta

Version 15.2.0-beta

Version 15.1.0-beta

Version 15.0.3-beta

Version 14.6.1

Version 14.6.0

Version 14.5.0

Version 14.4.0

Version 14.3.0

Version 14.2.1

Version 14.2.0

Version 14.1.0

Version 14.0.1

Version 14.0.0

There are three new options to massively parallel processing: Azure Container Apps, Kubernetes and Azure Container Instance!

Batch node pools are now created with assigned Managed Identities. Because of this, the workstation running sbm needs to have a valid Azure authentication token. This can be done via Azure CLI az login, Azure PowerShell Connect-AzAccount, or if running from an automation box, ensure that the machine itself has a Managed Identity that has permissions to create Azure resources. Alternatively, you can pre-create the batch pools manually via the Azure portal, being sure to assign the correct Managed Identity to the pool.

Kubernetes, Azure Container Apps, and Azure Container Instance also require local machine authentication (az login) in order to access Azure Key Vault. Authentication is not needed for local or threaded builds

The keys, connection strings and passwords can now be stored in Azure Key Vault rather than saving the encrypted values in a settings file or being passed in via the command line. Regardless if you use Batch, Kubernetes or ACI , this integration is enabled by leveraging User Assigned Managed Identities. To easily accomplish this setup, there are a set of PowerShell scripts in the scripts/templates folder. A complete environment can be created with create_azure_resources.ps1. Please note that Azure Key Vault is required for Azure Container Instance builds.

You will also need to be logged into Azure if you are leveraging Azure Key Vault to store your secrets, regardless if you are using Azure Batch, Kubernetes, Azure Container Apps, or Azure Container Instance

Version 13.1.0

Version 13.0.4

Version 13.0.3

Version 13.0.2

Version 13.0.1

Version 13.0.0

Version 12.1.0

Version 12.0.0

Version 11.3.1

Version 11.3.0

Version 11.2.0

Version 11.1.0

Version 11.0.0

Version 10.4.4

Version 10.4.3

Version 10.4.2

Version 10.4.1

Version 10.4.0

Version 10.3.0

Version 10.2.12

Version 10.2.11

Version 10.2.10

Version 10.2.9

Version 10.2.8

Version 10.2.7

Version 10.2.6

Version 10.2.5

Version 10.2.4

Version 10.2.2

Version 10.2.1

Version 10.1.1

Version 10.1.0

Version 10.0.0

Version 9.2.2

Version 9.2.1

Version 9.1.0

Version 9.0.0

Version 8.8.2

Version 8.8.1

Version 8.8.0.1

Version 8.7.3

Version 8.7.2

Version 8.7.1

Version 8.7.0

Version 8.6.13

Version 8.6.12

Version 8.6.11

Version 8.6.10

Version 8.6.9

Version 8.6.8

Version 8.6.7

Version 8.6.6

Version 8.6.5

Version 8.6.4

Version 8.6.3.1

Version 8.6.3

Version 8.6.2

Version 8.6.1

Version 8.6.0

Version 8.5.10

Version 8.5.9

Version 8.5.8

Version 8.5.7

Version 8.5.6

Version 8.5.5

Version 8.5.4

Version 8.5.3

Version 8.5.2

Version 8.5.1

Version 8.4.0

Version 8.3.9

Version 8.3.8

Version 8.3.7

Version 8.3.6

Version 8.3.5

Version 8.3.4

Version 8.3.3

Version 8.3.1

Version 8.3.0

Version 8.2.0

Version 8.1.13

Version 8.1.12

Version 8.1.10

Version 8.1.8

Version 8.1.7

Version 8.1.6

Version 8.1.5

Version 8.1.4

Version 8.1.3

Version 8.1.0

Version 8.0.5

Version 8.0.4

Version 8.0.3

Version 8.0.2

Version 8.0.1

Version 7.6.9

Version 7.6.8

Version 7.6.7

Version 7.6.5

Version 7.6.4

Version 7.6.2

Version 7.6.1

Version 7.6.0

Version 7.5.5

Version 7.5.3

Version 7.5.2

Version 7.5.1

Version 7.5.0

Version 7.4.11

Version 7.4.6

Version 7.4.5