SQL Server CI/CD Azure DevOps | SQL Server Azure DevOps | Auto Build Auto Deploy SQL Server | Part 2

SQL Server CI/CD using Azure DevOps | SQL Server Azure DevOps | Continues Integration SQL Server
Continues Integration of SQL Server Database and Continues Deployment on On-premises and Azure Database using Azure DevOps
#SQLServer
#SQLServerAzureDevOps
#AzureDevOps
#SQLServerAutoBuild

SQL Server CI/CD using Azure DevOps

1. Create Database Project in VS
2. Push to GitHub Repo
3. Build Solution in Azure DevOps
4. Continues Integration dacpac file
5. Release On premise UAT DB
6. Release Azure Test DB
8. Continues Deployment UAT DB

[leoliu]

Thanks, this is great content. Will be good to have a part 3 about how to handle pre/post deployment scripts as part of the CICD process

[bnisrael]

This is a very straightforward tutorial without complicating it too much, thanks a lot! Please post more content on Azure DevOps.

[SoumikBhattacharjee-rwkg]

Very nicely explained with each steps..Thanks..

[onkarpatil]

you are awesome !! This is exactly what i was looking for. Why did you stop creating more videos. You should create. Its helping everyone. Thanks a ton again !!

[KiranCK]

One of the best video I have found, I’m searching many videos in the internet for azure devops, can you please make more videos with same accuracy, your explanation is very good, thankyou😊

[bala]

Excellent job . Pls do more vedio.. sql learning .. coding standard. It will help full us. Thank you...

[FishingBolts]

Why are you Jilooo restricting your skills to just these two sessions? If you continued to upload videos like this, the other tech channel's ranking would decline. You are fantastic.

[narendrabestha]

Are you facing any issue while pushing schema changes? I am facing issues while deploying using CI/CD pipeline. Deployment is failing due to error " Rows were detected. The schema update is terminating because data loss might occur". Any idea guys? How to use pre and post deployment scripts?

[sumanthr]

Hi..is there any other video which explains redeployment process

[spiderdudeMarlon]

Can you help me? it builds, it releases, but when i go to watch the changes it seems did nothing.

[kavacham]

Hi thanks for the video. I am using yaml file... Problm is when i am working on my Feature branch the Tag value is 1.0.1 but when merging with Develop its getting changed to 272.1.0. why any idea Plz tell me . The git version is same for all my services.

[kavacham]

And can I push my Nuget pack into Multiple organisation from the same pipeline..?? If yes then how can I do it?

[nageshkumar]

Hi jiloo, can you please do one video for Deploy SQL Using: Sql Query File using deployment group I am facing issue :No files were found to deploy with search pattern
Note : but file is there