Skip to content

Instantly share code, notes, and snippets.

@kunalworldwide
Created February 21, 2023 05:07
Show Gist options
  • Save kunalworldwide/d4efc57e0282e96a77df9e28ac53b20f to your computer and use it in GitHub Desktop.
Save kunalworldwide/d4efc57e0282e96a77df9e28ac53b20f to your computer and use it in GitHub Desktop.
# @Author : Kunal Das
# Date : 30-12-2022
variables:
poolstagingarea: $(Build.ArtifactStagingDirectory)\poolstaging
BuildConfiguration: release
SQLPoolartifactname: AzureSQLPool
SQLPooldacpacfile: $(System.ArtifactsDirectory)\$(SQLPoolartifactname)\synapseSQLpoolDEV.sqlproj
trigger:
- main
pool:
vmImage: windows-2019
stages:
- stage: Pooldacpac
displayName: 'Build dacpac'
jobs:
- job: 'Builddacpac'
displayName: 'Build SQL Pool dacpac'
steps:
- task: VSBuild@1
displayName: 'Builds the dacpac'
inputs:
solution: synapseSQLpoolDEV.sqlproj
configuration: $(BuildConfiguration)
- task: PublishBuildArtifacts@1
displayName: 'Publishes dacpac as an artifact'
# Publishes the dacpac as part of an artifact within Azure DevOps
inputs:
PathtoPublish: 'bin\$(BuildConfiguration)'
ArtifactName: $(SQLPoolartifactname)
publishLocation: 'Container'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment