I have a powershell step that restores a DACPAC to a SQL Sever instance. This runs on any SQL role in my DEV environment. (which happens to have only one SQL machine)
IF I have 2 SQL Instances within a high availability group, running the DACPAC restore should point to the availability group cnn string (rather than an individual instance within the group).
BUT where will the tentacle code be ran? Should I just add the target machine using the availability group URL ? Or will the Powershell script step need to run on a target within the availability group- so will I need to add one of the instances within the group as a target?