Complete series of Azure SQL database deployment using Azure DevOps CI/CD pipeline

Complete series of Azure SQL database deployment using Azure DevOps CI/CD pipeline

Introduction and creation of DACPAC file using SSMS - 00:00-05:40
Introduction and creation of Visual Studio .sln file and importing .dacpac file to the project - 05:40-10:50
Database build (DacPac) creation using Azure DevOps build pipeline - 10:50-21:40
Database auto-deployment using Azure DevOps release pipeline - 21:40-31:18

Work Flow:
i. Download Adventure sample database from Microsoft Website
ii. Restore Database using SSMS
iii. Create a .dacpac file using the sample database
iv. Create a Visual Studio solution package file
v. Creating CI/CD pipeline on Azure DevOps
vi. Deploying Azure SQL database

Please clone the project .sln and .dacpac from below GIT location

Follow us on Instagram @devopsmela

Like, Share and Subscribe

By any means, if my video has helped you, please leverage your support by buying me a coffee, Thanks!!

[mayurkrish]

Very comprehensive Video! It has helped me to conduct the POC for and help advocate using DevOps for our SDLC work. Thanks!

[azurelearner]

Thanks for the SQL deployement videos

[maheshkchacko]

thank you so much for this valuable information

[shyamjithsa]

Great effort.. Looking forward to see more videos on Azure DevOps

[vinithag]

It's too good... Do u have any free online class session taken .. pretty new wanna start with devops and azure.. unable to know the start wat to learn if it's devops first then azure. Or reverse .

[azymd]

Good explanation. After deploying the dacpac changes to DB, if we modify some tables or SP in dacpac, how it will be deployed again to DB ? Only the changes will be deployed or full db will be deployed ?what about data stored already in dB ?

[NK-xwuu]

Very valuable video. Please can you tell me what release pipeline task needs to be used when the target sql db is on a Azure vm? (Rather than Azure sql)

[hemantkumarsharma]

Hello sir Thanks for ur videos

Sir I have one question that problem is our SQL server | not able to connectivity onpremise SQL server from function App?
What solution is required in this scenario there is 404 error is occured...pls reply quick I am waiting

[AniyaRajVlogs]

Quite helpful rather than other videos.. so how did u push the sln file to repos

[asharnavya]

won't you take care of data that is already deployed on the database? Will, you not create .bacpac? if not then why you haven't created it. Please share with us.

[RajsekharR-fd]

Hello Sir. Can you please advice how to do multi database deployment using CI CD. In my case there are more than 100 Databases. Thanks

[ManishKumar-xisw]

But one thing is there when I am creating projection and importing dacpac file then it is showing only table folder actually I have created a database my own and created two table in that and just create project from that. So is it fine that it will showing only dbo and inside dbo table folder and than tables like
dbo -> tables - > tbl1, tbl2

And you have lot of folders I am not sure why this is happening. Can you please help me that is it fine or not

[dilipmevada]

Hi Rohit, How can we continue same release to dev, qa and prod using release pipeline?

[ManishKumar-xisw]

I have question if you reply on videos comment so do reply:
This could be the first scenario where you need to create db on you Database service in azure but what about the changes like in next time when I have some work to do in db and there are some column changes and SP changes then what I need to do?
How to make dacpack files with script which I need to give? Hope you understand this thing.
Second thing can I add this step in my CI pipeline and CD pipeline for which I have created for application deployment means can I add this extra step for db change in exiting pipeline or not?

[azurelearner]

DO you provide training ON AZURE DEVOPS.

[dev]

Hi bro will this work for oracleDB..
Please clarify me

[redgamershezz]

Thank you for the video, i followed all your steps with same dacpac file. But after all this if i do some new changes from visual studio, i am not able to commit, it says "unable to process path Adventure.dbmdl, " Can you please debug this?

[manichowdary]

Hi, I have one question that makes you laugh anyway my question is why we need database cicd and what is the use can you please help me on this