I’m just looking a bit of help really.
I have a project that deploys a DACPAC through a life-cycle of DEV, TEST, PRE-PROD and PROD. The deployment targets are setup as a “Jump Box” with the SQL Client Tools installed so the database objects are installed from there (this is actually the same box with 4 tentacles installed for the 4 environments).
The bit I’m trying to get my head around is that for 1 of these environments the DACPAC actually needs to be deployed to 2 different SQL Servers (PROD). The rest just go to a single server each. Since there is not an tentacle installed on each of the SQL Servers and I am just using a Jump Box model for this, would I be able to setup the project to achieve this?