Developing CI/CD pipeline for SQL server- Part 2
In this video, we will create a Continuous Delivery(CD) Pipeline for SQL server by using Azure DevOps.This will maintain the version control without disturbing the state persistency of the SQL database.
In Part-2 of this video, we will create a continuous Delivery pipeline Azure SQL server to deploy the latest changes to a different environment. Please watch the previous video to generate.DACPAC file which will be deployed by using a CD pipeline.
Developing CI/CD pipeline for SQL server- Part 1: • Developing CI/CD pipel...
Пікірлер: 22
thank you very much, really helped me
Very nice explanations
Nice video good work ❤️
Nice videos!
@AnshumanDikshit
2 жыл бұрын
Thanks Lucas
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
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.
If the azure sql is not accessible over the internet and its only having private url access, then can we deploy like this?
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.
Thanks for your video.. Really worth. How can we do the same for Normal SQL server ( not in azure ) deployment in ci cd
@AnshumanDikshit
2 жыл бұрын
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?
@AnshumanDikshit
2 жыл бұрын
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?
How can we deploy data also using ci CD pipelines
@AnshumanDikshit
2 жыл бұрын
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?
@AnshumanDikshit
2 жыл бұрын
This is not related to data...this is related to metadata
How to push sql store procedures to azure ci cd pipeline
@AnshumanDikshit
2 жыл бұрын
If you already have store procedures ,you can import them in sqlserver project in visual studio
@AniyaRajVlogs
2 жыл бұрын
@@AnshumanDikshit ok and after importing it in vs.. i can push it in the repos of devops... right?
@AnshumanDikshit
2 жыл бұрын
@@AniyaRajVlogs yes