PublishDacPac Feature Request: Generate schema change script action

[binte]

I am trying to allow a pipeline to publish a schema change to an on-premises SQL Server 2017 instance, but I want to do that in two steps:

• Generate schema change script action
• After approval, publish

I know that can be achieved by publishing to SQL Azure by setting deploymentAction: 'Script' and then deploymentAction: 'Publish'

Can this be done by using this extension? I have gone through the documentation, and it does not seem possible. If so, can you provide an example?

[DrJohnT]

The whole point of SSDT / DACPACs methodology is that they generate a SqlCmd script on-the fly depending upon the status of the target database. Personally, I let the tool do its job. However, I understand for some shops, they will want to see the change script. I will take a look at adding this feature request sometime in the future. If you fancy your hand, you could add it to the underlying PowerShell module PublishDacPac yourself and issue a pull request. https://github.com/DrJohnT/PublishDacPac