Azure Devops "Perform DeployFromPackage" fails due to serverless Azure SQL DB paused

PeterDanielsCRB

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.

Thank you,

-Peter

Sergio R

Hi Peter,

I am afraid that the SQL Change Automation Azure Devops addons do not provide an option to reconnect if the first attempt fails.
It looks like an Azure SQL Server Serverless database will auto-resume approximately 1 minute after triggered.
So the way to go is to run a custom Powershell script before the SCA task.
You can possibly use the Test-DatabaseConnection cmdlet to trigger the wakeup and put a delay of at least 60 seconds before ending the task.

Kind Regards,

PeterDanielsCRB

Thank you, @Sergio R.  That's what I figured.  I already have similar functionality in some of my powershell scripts that interact with Azure SQL DB.  Cheers.