What are the challenges you face when working across database platforms? Take the survey
Options

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

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
Tagged:

Answers

  • Options
    Eddie DEddie D Posts: 1,789 Rose Gold 5
    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
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.