Multi-Database Deployments with SQL Change Automation using Azure Pipelines

Deploying to one database is straightforward -- but what happens when you need to deploy to hundreds?

This pattern is common for those who use a single-tenant database architecture, or use other methodologies to shard data across multiple databases.

In this class Redgate's Daniel Pottenger shares techniques which enable you to harness the power of Azure Pipelines with SQL Change Automation.

Grab the code samples here:

  • * Release task - https://github.com/Rixium/ExamplePipeline/blob/master/deploy-from-package.yaml
  • * Example code to define a pipeline using YAML: https://github.com/Rixium/ExamplePipeline/blob/master/pipeline.yaml