I have a query as the document states that VSBuild@1 task can be executed only in Windows VM. So is there any way we can do all these steps in a linux VM?
Great knowledge sharing. I have a query if you could answer. Why you are creating a separate pipeline for SQL deployment. Can not we have tools to deploy the SQL artifacts with code? I have a big project which has three components to deploy together. Angular for UI, .Net core for API and SQL tables and procedure. when a developer completes the development of a new functionality then he commits Angular code, API code and SQL tables and stored procedures. Now the challenge is to deploy all these three parts together ( in sequence of course ) through Ci/CD. I do not see any way to do this. I have googled it but did not find the solution. For code , CI/CD pipelines is there but it is not in sync with the SQL objects. Do we have any way to do this?
I have a self-hosted agent, with the sqlpackage capability enabled and my pipeline fails on the SQL Azure DacPacDeployment task with the following error: The current operating system is not capable of running this task. That typically means the task was written for Windows only. For example, written for Windows Desktop PowerShell. I am not quiet sure where does the task pickup the non windows OS.
Thank you for the interest in this episode, and also the question. At this moment I cannot adequately diagnose what might be causing this error, as it will be very specific to the environment. To rule out known issues, I would suggest following the below check list: - Ensure that the Visual Studio 2019 build tools are installed on the self-hosted agent. Build tools can be downloaded by searching in the page visualstudio.microsoft.com/downloads/ - scroll down and you'll find sections for Visual Studio 2019 Tools - expand that and then locate the build tools download. - Register self-hosted Agent from ADO following the instructions here: docs.microsoft.com/en-us/azure/devops/pipelines/agents/agents - Ensure that a current version of DacFx is installed. You can get this from docs.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-download - the latest at this point in time is 15.0.5164.1 -Ensure that the self-hosted pool is correctly referenced in your pipeline job as shown in the example: github.com/arvindshmicrosoft/azure-sql-devops/blob/9a7f249e23540374d8eb3755294d1c459ca27b22/azure-pipelines/deploy-sqlproj.yml#L57-L58 If the error still persists, consider opening an issue on github.com/microsoft/azure-pipelines-tasks/issues and cross-reference the issue here so that one of us can take a deeper look. In the GitHub issue, please provide as many details as possible (without revealing any sensitive / private information, of course). For example, the pipeline definition YAML would help. In addition, the details about the self-hosted runner / agent etc. would be required.
@@MicrosoftDeveloper I had two stages, one for building the project the other one for deploying the dacpac. In each stage there was a pool specificed and removing the ubuntu-latest fixed the problem. I am able to deploy the dacpac successfuly.... Many Thanks for your response....
You can use the Azure Pipelines YAML editor (docs.microsoft.com/en-us/azure/devops/pipelines/get-started/yaml-pipeline-editor?view=azure-devops), which offers some "IntelliSense", as a starting point.
In the description they provide a link to a playlist, where you can check all the episodes: aka.ms/dataexposedyt I think this is the particular episode they're referring to: ua-cam.com/video/j7OnxOz7YDY/v-deo.html
I have an linux sles VM , will that not work for deploying dacpacs? Am using github.
.dacpacs rocks!!!!
I have a query as the document states that VSBuild@1 task can be executed only in Windows VM. So is there any way we can do all these steps in a linux VM?
What if you have 100 databases you want to deploy to? How can you dynamicly supply the database list and how does the deployment work?
pls send the link to the yaml pipeline
Do we have steps to create SQL deployment scripts and incremental sql deployment scripts? like Differential scripts?
informative content. thanxs for putting together the go-through..
Very informative. Thank you
Great knowledge sharing. I have a query if you could answer. Why you are creating a separate pipeline for SQL deployment. Can not we have tools to deploy the SQL artifacts with code? I have a big project which has three components to deploy together. Angular for UI, .Net core for API and SQL tables and procedure. when a developer completes the development of a new functionality then he commits Angular code, API code and SQL tables and stored procedures. Now the challenge is to deploy all these three parts together ( in sequence of course ) through Ci/CD. I do not see any way to do this. I have googled it but did not find the solution. For code , CI/CD pipelines is there but it is not in sync with the SQL objects. Do we have any way to do this?
Sure - you can take the example from this repo wherein a single pipeline is used to orchestrate a SQL + web app deployment.
I have a self-hosted agent, with the sqlpackage capability enabled and my pipeline fails on the SQL Azure DacPacDeployment task with the following error:
The current operating system is not capable of running this task. That typically means the task was written for Windows only. For example, written for Windows Desktop PowerShell.
I am not quiet sure where does the task pickup the non windows OS.
Thank you for the interest in this episode, and also the question. At this moment I cannot adequately diagnose what might be causing this error, as it will be very specific to the environment. To rule out known issues, I would suggest following the below check list:
- Ensure that the Visual Studio 2019 build tools are installed on the self-hosted agent. Build tools can be downloaded by searching in the page visualstudio.microsoft.com/downloads/ - scroll down and you'll find sections for Visual Studio 2019 Tools - expand that and then locate the build tools download.
- Register self-hosted Agent from ADO following the instructions here: docs.microsoft.com/en-us/azure/devops/pipelines/agents/agents
- Ensure that a current version of DacFx is installed. You can get this from docs.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-download - the latest at this point in time is 15.0.5164.1
-Ensure that the self-hosted pool is correctly referenced in your pipeline job as shown in the example: github.com/arvindshmicrosoft/azure-sql-devops/blob/9a7f249e23540374d8eb3755294d1c459ca27b22/azure-pipelines/deploy-sqlproj.yml#L57-L58
If the error still persists, consider opening an issue on github.com/microsoft/azure-pipelines-tasks/issues and cross-reference the issue here so that one of us can take a deeper look. In the GitHub issue, please provide as many details as possible (without revealing any sensitive / private information, of course). For example, the pipeline definition YAML would help. In addition, the details about the self-hosted runner / agent etc. would be required.
@@MicrosoftDeveloper I had two stages, one for building the project the other one for deploying the dacpac. In each stage there was a pool specificed and removing the ubuntu-latest fixed the problem. I am able to deploy the dacpac successfuly.... Many Thanks for your response....
Is there a way to do this without hand-editing YAML?
You can use the Azure Pipelines YAML editor (docs.microsoft.com/en-us/azure/devops/pipelines/get-started/yaml-pipeline-editor?view=azure-devops), which offers some "IntelliSense", as a starting point.
some one can say to me where is the previous video?
In the description they provide a link to a playlist, where you can check all the episodes: aka.ms/dataexposedyt
I think this is the particular episode they're referring to: ua-cam.com/video/j7OnxOz7YDY/v-deo.html
Could not he show the delta changes... selling too many shells!