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 .
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)
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..
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..
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…
Hi Dilip, you can create multi stage release and use the same artifacts for the deployment, the multi stage deployment is covered in my Azure DevOps topics.
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..
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!!
@@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
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?
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..
Thanks for the SQL deployement videos
Very clear, thanks!
Great effort.. Looking forward to see more videos on Azure DevOps
Great video ...nice explanation 👏
thank you so much for this valuable information
Welcome!!
Excellent tutorial!
Thanks! For you valuable feedback…
great videos, very well done.
Thanks!! For your valuable feedback..
excelent! Thanks you!
welcome!!
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
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…
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
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
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..
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
Hello Rajaekhar, You need setup .dacpac project for each database and have dedicated CI/CD pipelines for them…
Thank you
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 👍👍👍👍👍👍
Hi Rohit, How can we continue same release to dev, qa and prod using release pipeline?
Hi Dilip, you can create multi stage release and use the same artifacts for the deployment, the multi stage deployment is covered in my Azure DevOps topics.
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..
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!!
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
DO you provide training ON AZURE DEVOPS.
Write to us at devopsmela@gmail.com for more information
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