@sandeep-bp2tu
pls send the link to the yaml pipeline
@sau002
Very informative. Thank you
@seanrhone5306
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?
@MunindherReddy
Do we have steps to create SQL deployment scripts and incremental sql deployment scripts? like Differential scripts?
@greetymargretpious3391
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?
@ALLInOne-nn6ny
I have an linux sles VM , will that not work for deploying dacpacs? Am using github.
@pankajkrlakhchaura
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?
@fudhater8592
Is there a way to do this without hand-editing YAML?
@remandlo
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.
@omarvega6940
some one can say to me where is the previous video?
@hydtechietalks3607
Could not he show the delta changes... selling too many shells!
@mjonausk
.dacpacs rocks!!!!
@remandlo