Complete series of Azure SQL database deployment using Azure DevOps CI/CD pipeline
HTML-код
- Опубликовано: 8 июн 2024
- 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
gitlab.com/rohit.kumar.singh0...
Follow us on Instagram @devopsmela
Write to us at devopsmela@gmail.com
Like, Share and Subscribe
By any means, if my video has helped you, please leverage your support by buying me a coffee, Thanks!!
buymeacoffee.com/rohitkumarsingh
Thanks for the SQL deployement videos
Very comprehensive Video! It has helped me to conduct the POC for and help advocate using DevOps for our SDLC work. Thanks!
Thanks!! Great to hear that..
Great video ...nice explanation 👏
Very clear, thanks!
Great effort.. Looking forward to see more videos on Azure DevOps
thank you so much for this valuable information
Welcome!!
great videos, very well done.
Thanks!! For your valuable feedback..
Excellent tutorial!
Thanks! For you valuable feedback…
excelent! Thanks you!
welcome!!
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
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)
Hello NK, please go ahead and add ‘sql dacpac’ task and not ‘Azure sql dacpac’ task to deploy it on Sql servers running on Azure VM…
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 ?
If modifying the existing objects then only the new change will get deployed and dacpac will not drop or delete anything for you, if any objects or data getting deleted the dacpac pipeline will fail..
@@DevOpsMela Thanks for your reply. If I delete any table or sp in dacpac will those table and sp will be deleted from database when we redeploy?
No it won’t
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 .
Hi Vinitha, kindly write ✍️ us at devopsmela@gmail.com with your query
Quite helpful rather than other videos.. so how did u push the sln file to repos
Thanks!! For the valuable feedback and if noticed I already had repository created and I have imported the dacpac inside the repository and post development I pushed the entire change to the remote repo..check out my end to end Azure DevOps course for more info..
@@DevOpsMela how did you push that sln file into your repos in devops?
@@DevOpsMela if you can help me with the references.. it will be great
DO you provide training ON AZURE DEVOPS.
Write to us at devopsmela@gmail.com for more information
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.
Hello Ashish,
Bacpac is created if you want to take complete backup of a database where in dacpac takes care of structural aspect of database and for CI/CD that is what it is needed..
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
Yes, that is correct if it is showing dbo folder content…and if you want to view and other folders inside your project then you need to add it…
Click on show all files option then you can see all other folders too…
@@DevOpsMela I get you big fan with your quick answers 👍👍👍👍👍👍
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?
Hello Manish,
Yes, once the dacpac is created you can use the same for modifications too (For Ex: Adding extra column in an existing table) and the same can be integrated with CI/CD pipelines by creating a visual studio database project and importing dacpac in it..
Hopefully that helps..
Thanks!!
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?
Kindly send error screenshots on devopsmela@gmail.com
Hi bro will this work for oracleDB..
Please clarify me
Hey Ganesh, the method works for MS Sql not for OracleDB…
You can try redgate for OracleDB automation
Thanks!!
@@DevOpsMela u r a very good person🤝🏻.. thank u so much for ur response🙏🏻..
bro pls don't mind, if possible pls share any best link to work with oracleDB deployment.. I'm in a serious need.. please
@@DevOpsMela bro if possible could you please make a video on it.. that would be a great help
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
Hello Mani,
Now our days all our front end development is automated through CI/CD then why not backend? most of cases we are still send sql scripts manually to DBAs and they are running it manually on ell envs…which has many disadvantages…like prone to error, time consuming, inconsistent etc.
Where as all the above issues will be fixed with CI/CD…
Thanks..