I have a requirement where I need to automate mongo DB script execution through Azure CI/CD pipeline as we are using Azure CI/CD for code deployment. We want to automate Mongo DB script execution also with pipeline.
Is there any way to execute DB script through pipeline by picking script from storage account or file directory?.
I checked and found these doesn't have any built-in task to picking script from storage account or file directory.
You can choose to use powershell to download the script to agent and run it.
But I more recommend you to upload DB script to specific folder in branch. And then triggered by the folder in branch.