Skip to content
867545c
Compare
Choose a tag to compare
  • NEW: You can now use Kubernetes as a compute platform for leveraging database builds with the new sbm k8s commands. See the Kubernetes documentation for background, information and how-to examples
  • NEW: You can now use Azure Container Instance as a compute platform for leveraging database builds with the new sbm aci commands. See the ACI documentation for background, information and how-to examples
  • ADDED: New Azure Key Vault integration -- secrets can now be stored in Key Vault and no longer need to be stored in the settings file or passed via command line. See the documentation here
  • IMPORTANT: 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 Batch resources.
  • UPDATED: Automation scripts /scripts/templates have been updated to simplify the creation of Azure resources, runtime, secrets file and pushing secrets to Key Vault. See info here
  • UPDATED: Batch and Kubernetes now have Managed Identity assigned to allow seamless access to Key Vault
Compare
Choose a tag to compare
  • UPDATED: The sbm create command now has four sub-commands fromscripts, fromdiff, fromdacpacs and fromdacpacdiff. See the Command Line Reference for details and usage
  • NOTE: The sbm scriptextract command is being deprecated in favor of sbm create fromdacpacdiff and will be removed in a future release
  • UPDATED: Corrected how the sbm build local build command handles logging. It is now all encapsulated in the .sbm file as it should be
  • UPDATED: Documentation updates and improvements
03beb43
Compare
Choose a tag to compare
  • ADDED: New command sbm add to add scripts to an existing SBM package or SBX project file from a list of scripts
  • ADDED: New command sbm list to output script information of SBM packages (run order, script name, date added/modified, user info, script ids, script hashes)
  • UPDATED: The sbm create command can now also create an SBX project file, not just an SBM package
  • UPDATED: Tabular output for sbm policycheck command to make it easier to read. Defaulting enterprise config to GitHub file.
db67c1d
Compare
Choose a tag to compare
  • FIXED: Update to Dacpac change scripts to identify new header delimiter
  • FIXED: Issue creating scripts between incompatable SQL Server versions. Will now output a warning and continue to create the scripts with the flag AllowIncompatiblePlatform=true
  • ADDED: New command sbm create to create a new SBM file from a list of scripts
  • UPDATED: Can now use Windows auth for DACPAC creation
  • UPDATED: updated Nuget packages
0738839
Compare
Choose a tag to compare
  • FIXED: Update to ensure all Queue messages are retrieved efficiently
  • ADDED: New utility method sbm batch dequeue to remove all messages from the Service Bus Queue topic (without processing them)
  • UPDATED: Code clean up and refactoring to accommodate latest version of System.CommandLine
  • FIXED: Issue with SQL text syntax higlighting formatting in .NET 5.0
  • NOTE: Removed "Construct Command Line" menu options from Windows UI. Users should leverage the generated help docs for sbm.exe
1d102c8
Compare
Choose a tag to compare
  • FIXED: Updated distribution algorithm for --concurrencytype of Server and MaxPerServer when number of Batch nodes is very close to the number of SQL Server targets. Was yielding less than the number of nodes.
  • FIXED: Updated Service Bus message retrieval to better manage when messages not matching the job name are in large quantity
6712b32
Compare
Choose a tag to compare
  • ADDED: New option to leverage Azure Service Bus Topic as a database target source. See the Azure Batch and Override Options docs for more detail
  • ADDED: New command option --settingsfilekey, a key for the encryption of sensitive information in the settings file. If provided when saving the settings file, it of course must also be provided when using the settings file. This version moved away from a static (and not really secure) encryption key used prior. The argument value can be either the key string or a file path to a key file. The key may also be 'silently' provided by setting a sbm-settingsfilekey Environment variable. If not provided a machine value will be used.
    UPDATED: Removed log4net logging. Unified logging via ILogger created in SqlBuildManager.Loggging. Implements Serilog
2a73be6
Compare
Choose a tag to compare
  • NOTE: Removed old style command line (leveraging the /Action=verb flag etc.). Run sbm --help for instructions
  • NOTE: Now built against .NET 5 and .NET Core 3.1
  • ADDED: New threaded and batch command options: --concurrency and --concurrencytype. See docs on Concurrency Options
  • UPDATED: Now leveraging Microsoft.SqlServer.DACFx Nuget package instead of sqlpackage.exe command line to manage DACPACs
  • FIXED: Updated BlueSkyDev.Logging.AzureEventHubAppender to v1.3.2 due to app hanging if EventHub connection string was incorrect
Compare
Choose a tag to compare
  • UPDATED: Changes tp the deployment templates and PowerShell files to be more friendly with Azure DevOps release pipelines
  • FIXED: sbm batch run regression introduced with new query option
e5fb4b6
Compare
Choose a tag to compare
  • NOTE: The old style command line (leveraging the /Action=verb flag etc.) will be deprecated soon!
  • ADDED: New querying across databases from command line for threaded [sbm threaded query] and batch [sbm batch query]. Brings the existing UI feature (Action-> Configure Multi server/Database run-> Reports -> Adhoc Query Execution) to command line
  • UPDATED: Running a threaded update is now performed via [sbm threaded run] (vs just [sbm threaded]), now that there is also a query option for the threaded command