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. 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/ExamplePipe...
Example code to define a pipeline using YAML: https://github.com/Rixium/ExamplePipe...