Can I deploy to 200 databases at once using SQL Change Automation ?

Pramarao

In my company we have 200 database instances that need to be deployed during release

How do i perform automated deployment for 200 data base instances of SQL Server

Eddie D

Hi,
There are different ways that users may parallelize this, and it's a niche problem, so Redgate haven't built the capability into the Azure DevOps plug in. Running things in parallel often means that users want to distribute the work across nodes to be sure that the workload is balanced in an environment.

I would look at splitting up the for deployment, into smaller groups and set up a parallel process that might handle this for your environment using PowerShell.

Use the SQL Change Automation PowerShell Cmdlet New-DatabaseReleaseArtifact to create the release (once) and then Use-DatabaseReleaseArtifact cmdlet to deploy it.
https://documentation.red-gate.com/sca/deploying-database-changes/automated-deployments