Forum Discussion

VeronikaHolcnerova's avatar
VeronikaHolcnerova
Copper Contributor
Feb 26, 2024

Azure DevOps pipeline - how to deploy DB project to on-prem using custom path to SqlPackage.exe

Hi,    I've been trying to figure this out for a while, but can't find my way around it.    Our DevOps team has the SqlPackage.exe file saved in a custom location on a virtual machine used for th...
azure devops
Kidd_Ip's avatar
Kidd_Ip
MVP
Jun 14, 2025

Any chance on this and return result:

 

- task: PowerShell@2
  inputs:
    targetType: 'inline'
    script: '"C:\CustomPath\SqlPackage.exe" /Action:Publish /SourceFile:"$(Build.ArtifactStagingDirectory)/YourProject.dacpac" /TargetServerName:$(TargetServer) /TargetDatabaseName:$(TargetDatabaseName) -U $(SqlUsername) -P $(SqlPassword) /TargetEncryptConnection:False'

 

Resources