search

microsoft / azure-pipelines-tasks

Tasks for Azure Pipelines
https://aka.ms/tfbuild
MIT License
3.51k stars 2.62k forks source link

[BUG]: SqlAzureDacpacDeploymentV1 Drift Report output Path is not supported #20659

Open JFolberth opened 1 week ago

JFolberth commented 1 week ago

New issue checklist

Task name

SqlAzureDacpacDeployment

Task version

V1

Issue Description

Line 125 has the Output Path hard coded. This makes it impossible to pass in the Output path for the drift report as Powershell will error with Duplicate 'OutputPath' argument. In the meantime it looks like it is written to an ADO variable $SqlDeploymentOutputFile which could be use to copy to a new location.

azure-pipelines-tasks/Tasks/SqlAzureDacpacDeploymentV1 /SqlAzureActions.ps1

Environment type (Please select at least one enviroment where you face this issue)

Azure DevOps Server type

dev.azure.com (formerly visualstudio.com)

Azure DevOps Server Version (if applicable)

No response

Operation system

Windows

Relevant log output

Duplicate 'OutputPath' argument.

Full task logs with system.debug enabled

 [REPLACE THIS WITH YOUR INFORMATION]

Repro steps

JFolberth commented 1 day ago

Adding on this one cannot output multiple files as running a deploy and a drift report causes the files to be overwritten. As a workaround I am creating the deploy report, copy the results to another folder, run the drift report, copy results and then publish the entire folder.