How to pass a SQL variable in SQL change automation task ?
Souviksahoo
Posts: 1 New member
I need to create one SQL variable whose value can be passed through azure key vault.
Tagged:
Answers
As you've likely noticed, ADO only automatically maps non-secret variables. Secret ones need an additional step, please see the following guide for advice and an example.
https://documentation.red-gate.com/sca/deploying-database-changes/add-ons/azure-devops/access-azure-devops-pipeline-secret-variable-from-sql-scripts