search

microsoft / azure-pipelines-tasks

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

[enhancement]: Update SqlAzureDacpacDeploymentV1 to include SQL Server support #19636

Closed emdempster closed 1 month ago

emdempster commented 7 months ago

Task name

SqlAzureDacpacDeployment - SQL Server Compatibility

Describe your feature request here

With the deprecation of SqlServerDacpacDeployment@1, on-premises deployments are left without a 1st class YAML task. Reviewing the code in Tasks/SqlAzureDacpacDeploymentV1/DeploySqlAzure.ps1, Azure subscription information is only being used for telemetry and doesn't appear to be used by sqlpackage.exe.

It would be really nice if the Azure subscription Id/Name wasn't a required field. This would allow this task to be easily used for on-premises and other cloud SQL VM deployments.

As a secondary request, please allow Windows authentication as an option, as well for SQL VMs.

image

github-actions[bot] commented 1 month ago

This issue is stale because it has been open for 180 days with no activity. Remove the stale label or comment on the issue otherwise this will be closed in 5 days