I’m trying to find the optimal way to create a re-usabale step template for dacpac deployments to Azure. I’m aware the community template, however this requires a previous step to retrieve the NuGet package that the dacpac sits in, and then extract the files in a location that persists for the next dacpac deploy step to pick up on.
Now that script steps allow you to reference and retrieve packages, I was hoping to use that but it seems you can’t create a step template that allows the uses to dynamically select a package. It’s set in the step template itself and not configurable after that. Is there a way to allow this? If this could be done, it would mean that anyone could easily select the deploy dacpac step, select the package that’s right for them, alter a few parameters and off they go.
So what I’m currently doing is using the “Deploy Package” step, but this doesn’t allow worker pools and will require the deploy scripts to be included in the package at build time. However, I’d prefer to have that single, re-usable template, with worker pools, that doesn’t need to reference other steps.
Does anyone know if that’s possible? Many thanks.