title: Generate SQL Server schema change script on Azure DevOps pipeline
body: <p>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: </p>
  
  <ul>
  <li>Generate schema change script action</li>
  <li>After approval, publish</li>
  </ul>
  
  <p>I know that can be achieved by <a href="https://docs.microsoft.com/en-us/azure/devops/pipelines/tasks/deploy/sql-azure-dacpac-deployment?view=azure-devops" rel="nofollow noreferrer">publishing to SQL Azure</a> by setting <code>deploymentAction: 'Script'</code> and then <code>deploymentAction: 'Publish'</code> </p>
  
  <p>Is there a way to publish to an on-premises SQL Server in a similar way? I have tried the <a href="https://docs.microsoft.com/en-us/azure/devops/pipelines/tasks/deploy/sql-dacpac-deployment-on-machine-group?view=azure-devops" rel="nofollow noreferrer">SqlDacpacDeploymentOnMachineGroup</a> task, but it does not seem possible to do it in two steps with this task</p>