How to use a PAT to get SQL Compare to access Azure Devops without a manual login?
ShaneRMonroe
Posts: 1 New member
in SQL Compare
We recently moved from ON PREM TFS to cloud-based Azure DevOps.
We have some scripts (created by previous residents) that compare our database with a branch in TFS and generates our DIFF script.
Of course, when the scripts run, they are trying to hit the cloud and forcing a manual authentication - which ruins our automated deployment pipeline (we're using Octopus to call the script using SQL Compare).
We have gotten all the rest of our pipeline working using Personal Authentication Codes (PAT) and Redgate SEEMS to support this - but we cannot seem to get the authentication integrated into our scripts.
I've tried adding <email> and <token> values to the command line argsfile - and that doesn't seem to change anything - a login window continues to appear.
Any help, links, anything - would be most helpful.
Thank you!
We have some scripts (created by previous residents) that compare our database with a branch in TFS and generates our DIFF script.
Of course, when the scripts run, they are trying to hit the cloud and forcing a manual authentication - which ruins our automated deployment pipeline (we're using Octopus to call the script using SQL Compare).
We have gotten all the rest of our pipeline working using Personal Authentication Codes (PAT) and Redgate SEEMS to support this - but we cannot seem to get the authentication integrated into our scripts.
I've tried adding <email> and <token> values to the command line argsfile - and that doesn't seem to change anything - a login window continues to appear.
Any help, links, anything - would be most helpful.
Thank you!
