'The 'Query' and the 'InputFile' options are mutually exclusive. when using Azure SQL Database Deployment task
Title says it all - I am working with the Azure SQL Database Deployment task SqlAzureDacpacDeployment@1 in Azure DevOps and getting the below error:
##[error]The 'Query' and the 'InputFile' options are mutually exclusive.
I am not using the -Query flag in the configuration, so why am I getting this error?
Solution 1:[1]
I was passing in both additionalArguments: AND sqlAdditionalArguments: to the DevOps task - the mutual exclusivity is on these parameters on the task.
After consolidating my parameters into one of these, my deployment task now works.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Joe Plumb |