We have a MongoDB Atlas database with a few collections and we need to design the way how to do continuous delivery for the indexes, triggers and inject some data.
Until now we build the indexes using the Web UI of Mongo Atlas for our development enviroment but our customer have policies that don’t let us using this UI for production enviroment, so we need to think how to delivery changes of indexes, triggers and inject base data.
For example, we use Azure DevOps pipelines for our CI/CD to SQL Server, but we don’t have any idea of how we could build a delivery pipeline for MongoDB Atlas. There is a few ideas we have:
- Using an agent (vm) to install mongodb shell and run the scripts.
- Using the Mongo App Services API
- Build an Azure Function to run the scripts over the DB and call it from the pipelines.
¿in your expirience, what approach we should explore for this?
Thanks a lot for your help guys.