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.

[alwalravi]

I am getting below error, Can you please suggest on this one.

The unnamed foreign key between tables 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.

[DanielFantaneanu]

thank you very much, really helped me

[sankarm]

Thanks for your video.. Really worth. How can we do the same for Normal SQL server ( not in azure ) deployment in ci cd

[SureshS-seix]

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

[suncodings]

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?

[naturevibezz]

If the azure sql is not accessible over the internet and its only having private url access, then can we deploy like this?

[Dora]

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.

[AniyaRajVlogs]

How to push sql store procedures to azure ci cd pipeline

[sameergaonkar]

How can we deploy data also using ci CD pipelines