Azure devops pipeline
I am trying to checkout 2 repositories. The one which I’m running from is fine. The second repository. I retrieve a branch name from job 1. I then pass this branch name into the checkout of the second repository using inline commands and environmental variables. But it does not work.

Given this Azure DevOps yaml for a test pipeline:

I have pipeline A which is a build pipeline that produces artifacts, and I have pipeline B which has

I want to run a pipeline that looks like this:

I am using SQL Server database deploy task to deploy sql scripts to an on-prem SQL Server database. But the downside I see to this is I could only do 1 script at a time. This would work fine only when I have a small finite number of files but if the number of files increase this option would not scale up. What other options are available in Azure DevOps.

I’m trying to add displayName to my yaml code when deploying pipelines, however when I run the pipeline the displayName doesn’t appear.

In our git repo we have a folder called ExternalSQLScripts with sub-folders for Tables, Views, Functions, StoredProcedures etc. Loop through each sub-folder and execute all the .sql files on the external SQL Server. We only have access to just deploy the SQL Server database object scripts we cannot do a .dacpac database deploy.

I am attempting to build a Pipeline in AzureDevOps (without using the classic editor). I have so far created the following yaml code: