How can we help you today?

How can we help you today?

How to pass a SQL variable in SQL change automation task ?

I need to create one SQL variable whose value can be passed through azure key vault.

Souvik Sahoo November 01, 2022 09:12

0

Comments

1 comment

Hi Souviksahoo,

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

Peter_Laws November 10, 2022 15:45

0

Add comment

Please sign in to leave a comment.