search

DrJohnT / AzureDevOpsExtensionsForSqlServer

Microsoft SQL Server deployment extensions for Azure DevOps Pipelines
MIT License
21 stars 14 forks source link

Multiple instances #10

Closed maroliict closed 5 years ago

maroliict commented 5 years ago

Is there a way we can use these products to deliver a database to over 100 instances?

DrJohnT commented 5 years ago

Interesting requirement! Take a look at this blog which mentions the "Each" YAML component. https://mattvsts.github.io/2019/05/04/solving-the-looping-problem-in-Azure-DevOps-Pipelines/

Alternatively, you could write a PowerShell script that iterates over the server collection and uses my PowerShell module "Publish DacPac" https://www.powershellgallery.com/packages/PublishDacPac/ This is the same module my DevOps component uses to perform the deployment.