Azure Devops "Perform DeployFromPackage" fails due to serverless Azure SQL DB paused
We have an Azure DevOps pipeline and release configured that use "classic" (non-YAML) pipelines. We're also using the RedGate plugins for SCA build and release/deploy (for now). Our target DB is Azure SQL Database serverless. Often, it is paused and needs a little time to wake up. Unfortunately, the "Perform DeployFromPackage" task fails when the DB is paused, so we have to go in and redeploy manually. I was unable to locate a setting that would retry the deployment or change how it handled failed SQL connections. Any tips on how to handle this? I'm looking at a powershell script that runs prior to the "PerformDeployFromPackage" and wakes the instance up, but that has it's own complexities.
0 · Share on Twitter