Azure Pipelines: Build a SSDT Database Project (SQL Server Data Tools)

azure-pipelines.yml

parameters:
- name:     solutionFile
  type:     string
- name:     projectName
  type:     string
- name:     buildConfiguration
  type:     string
  default:  'Release'

variables:
  # Note: We need to replace dots with underscores ("A.B" -> "A_B") in project name
  projectNameSanitized:  ${{ replace(parameters.projectName, '.', '_') }}

steps:

  # https://learn.microsoft.com/en-us/azure/devops/pipelines/tasks/reference/vsbuild-v1
- task: VSBuild@1
  displayName:      '🏭 Build database project (SSDT)'
  inputs:
    solution:       ${{ parameters.solutionFile }}
    msbuildArgs:    '/target:$(projectNameSanitized) /p:OutputPath=$(Build.StagingDirectory)'
    platform:       'Any CPU'
    configuration:  '${{ parameters.buildConfiguration }}'