Tips and how-to guides for Redgate products
Ask, discuss, and solve questions about Redgate's tools
Meet us at an event, get sponsored, and join our Friends of Redgate
In-depth articles and opinion from Redgate's technical journal
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