Hello! Thank You very much for the video. I am new to CI/CD processes so I did not quite understand one thing. When exactly the process of building DACPAC is triggered? When any commit is made to the repository master branch? Is there a way to trigger deploying of DACPAC after every pull request is completed? I mean I want to design a process where dacpac is built and deployed to a few databases right after PR is made to master branch and it is completed(so now new changes are on master branch). What I try to achieve is to have automated process of applying changes FROM PR to database repository TO two databases I have. I would very appreciate any comments. Thank You!
I am getting below error, Can you please suggest on this one. The unnamed foreign key between tables [Config].[ProcessingQueryDetail] and [Config]. [DataSource] will be checked by checking the table. Name the foreign key to avoid checking the entire table and only check the new constraint.
Hi , Very well explained and easily understandable, can you please make the video on VM IIS server deployment with SQL server database using deployment group using Azure DevOps, Thanks
In GIT you have versions of each of the files with commit Id and you can rollback from there to a perticular previous commits ...once you do you can run the CICD pipeline again
I got this error ##[error]C:\Program Files (x86)\Microsoft Visual Studio\2019\Enterprise\MSBuild\Microsoft\VisualStudio\v16.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets(573,5): Error MSB4181: The "SqlBuildTask" task returned false but did not log an error.
Very nice explanations
thank you very much, really helped me
Hello! Thank You very much for the video.
I am new to CI/CD processes so I did not quite understand one thing.
When exactly the process of building DACPAC is triggered? When any commit is made to the repository master branch?
Is there a way to trigger deploying of DACPAC after every pull request is completed?
I mean I want to design a process where dacpac is built and deployed to a few databases right after PR is made to master branch and it is completed(so now new changes are on master branch). What I try to achieve is to have automated process of applying changes FROM PR to database repository TO two databases I have.
I would very appreciate any comments.
Thank You!
Nice video good work ❤️
I am getting below error, Can you please suggest on this one.
The unnamed foreign key between tables [Config].[ProcessingQueryDetail] and [Config].
[DataSource] will be checked by checking the table. Name the foreign key to avoid checking the entire table and only check the new constraint.
Hi , Very well explained and easily understandable, can you please make the video on VM IIS server deployment with SQL server database using deployment group using Azure DevOps, Thanks
If the azure sql is not accessible over the internet and its only having private url access, then can we deploy like this?
Thanks for your video.. Really worth. How can we do the same for Normal SQL server ( not in azure ) deployment in ci cd
In normal sql server same process can be followed ...the only change will be your web server where your sql server will he hosted
Nice vedio, Could you let me know how we can create rollback task while deployment CD pipeline task getting failed due to any know SQL issues?
In GIT you have versions of each of the files with commit Id and you can rollback from there to a perticular previous commits ...once you do you can run the CICD pipeline again
Can we maintain Versioning?
Nice videos!
Thanks Lucas
I got this error
##[error]C:\Program Files (x86)\Microsoft Visual Studio\2019\Enterprise\MSBuild\Microsoft\VisualStudio\v16.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets(573,5): Error MSB4181: The "SqlBuildTask" task returned false but did not log an error.
How to push sql store procedures to azure ci cd pipeline
If you already have store procedures ,you can import them in sqlserver project in visual studio
@@AnshumanDikshit ok and after importing it in vs.. i can push it in the repos of devops... right?
@@AniyaRajVlogs yes
How can we deploy data also using ci CD pipelines
Its not recommend...but still if you want to do it instead of DACPAC file you need to generate BACPAC file
And scripts to update data?
This is not related to data...this is related to metadata