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.

Azure Batch Command Reference

Azure Batch Save Settings

sbm batch savesettings [options]
This utility action will save a reusable JSON file to make running the command line easier for Batch processing.

The next time you run a build action, use the --settingsfile="<file path>" in place of the arguments below. If you provide a --keyvaultname parameter value, the secrets will be saved to the specified Azure Key Vault and not saved to the settings file. If you use this, you first must connect to Azure via the az login CLI command.

Can also optionally provide a --settingsfilekey value to provide a custom encryption key for encryption of the sensitive values (listed below). The value for the --settingsfilekey can be either the encryption key itself or the path to a text file containing the key.

Note:

  1. the values for --username, --password, --batchaccountkey, --storageaccountkey, --servicebustopicconnection and --eventhubconnectionstring will be encrypted. Use a --settingsfilekey value to manage encryption or use --keyvaultname to save them to Azure Key Vault
  2. If there are duplicate values in the --settingsfile and the command line, the command line argument will take precedence.

Pre-Stage Batch nodes

sbm batch prestage [options]
Note: You can also leverage the --settingsfile and --settingsfilekey options to reuse most of the arguments

Batch Execution

sbm batch run [options]
In addition to the authentication and runtime arguments above, these are specifically needed for Azure Batch executions.
Note:

  1. You can also leverage the –settingsfile and --settingsfilekey options to reuse most of the arguments
  2. either --platinumdacpac or --packagename are required. If both are given, then --packagename will be used.

Additional arguments

If you don’t run the sbm batch prestage and sbm batch cleanup [options] command sequence you will need to use the following:

Batch Clean Up Batch Nodes

sbm batch cleanup [options]
Note: You can also leverage the –settingsfile and --settingsfilekey options to reuse most of the arguments