Azure Pipelines - Generating DB Script with SqlPackage.exe: http://diegogiacomelli.com.br/azure-pipelines-generating-db-script/

azure-pipelines.yml

pool:
  vmImage: 'vs2017-win2016'

variables:
  buildPlatform: 'Any CPU'
  buildConfiguration: 'Release'
  dbProject: 'Set with the name of your Sql Server Database Project'
  targetDBConnectionString: 'Set with the connection string of the target database'
  
- task: VSBuild@1
  displayName: 'DB: build project'
  inputs:    
    solution: 'src\$(dbProject)\$(dbProject).sln'
    platform: '$(buildPlatform)'
    configuration: '$(buildConfiguration)'   
    
- task: CmdLine@2
  displayName: 'DB: script generation'
  inputs:
    script: |
      "c:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\130\sqlpackage.exe" ^
      /action:script ^
      /sourcefile:src\$(dbProject)\bin\$(buildConfiguration)\$(dbProject).dacpac ^
      /outputpath:db-script.sql ^
      /TargetConnectionString:"$(targetDBConnectionString)"      

- task: PublishBuildArtifacts@1
  displayName: 'DB: publish script'  
  inputs:
    pathtoPublish: '$(Build.SourcesDirectory)\db-script.sql'
    publishLocation: 'Container'
    ArtifactName: 'db-script.sql      

db-script-generate.yml

- task: CmdLine@2
  displayName: 'DB: script generation'
  inputs:
    script: |
      "c:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\130\sqlpackage.exe" ^
      /action:script ^
      /sourcefile:src\$(dbProject)\bin\$(buildConfiguration)\$(dbProject).dacpac ^
      /outputpath:db-script.sql ^
      /TargetConnectionString:"$(targetDBConnectionsTring)"  

db-script-publish.yml

- task: PublishBuildArtifacts@1
  displayName: 'DB: publish script'  
  inputs:
    pathtoPublish: '$(Build.SourcesDirectory)\db-script.sql'
    publishLocation: 'Container'
    ArtifactName: 'db-script.sql      

image.yml

pool:
  vmImage: 'vs2017-win2016'

solution-build.yml

- task: VSBuild@1
  displayName: 'DB: build project'
  inputs:    
    solution: 'src\$(dbProject)\$(dbProject).sln'
    platform: '$(buildPlatform)'
    configuration: '$(buildConfiguration)'