Skip to content
← SQL Change Automation

How can we improve SQL Change Automation?

SQL Change Automation

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Add Multisubnet failover support to Azure Devops pipeline plugin

When deploying to HA environments with servers in multiple subnets, you get an error if the sqlcmd runs on the wrong one. Per support the functionality was added to the powershell but was not exposed to the plugin.

4 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Scott Coleman shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Anonymous commented  ·   ·  Report

    100% agree with this one - although we ended up writing our own powershell based in-line tasks to do the work on a multi-subnet AoAG. Finding and using all the required variables that just "automagically" happens when you use the Extension was a pain - as was making sure everything worked when you have the create release artifact and deploy release artifact tasks separated (e.g. via a manual DBA/DBD review/approval step)