Deploy Stored Procedures from Source Control
It would be great if we could deploy sprocs from visualstudio.com as we can with Azure Functions or Azure Web Sites.
We are now planning on including support for deploying Cosmos DB stored procedures from our Resource Provider.
This will allow users to create stored procedures when deploying Cosmos resources from an ARM Template. Support will also be added to PowerShell and az cli in the near future as well.
Combined this capability will allow users to deploy Cosmos resources from templates or scripts when deployed from source control.
Will update here for future progress on this work.
Thank you for your suggestion.
Will Velida commented
Awesome to hear that this is now planned work! I'm assuming this will have support for updating existing Stored Procs as well as deleting them so I'm really looking forward to seeing this go live! Will this also be extended to Trigger and UDFs?
This can be done from Azure DevOps using powershell - and form there you could create a custome taks in Azure Devops to do this, so I wonder if the Devops Team might be more amenable to ensure that CosmosDB can be controlled as part of a CI/CD pipeline.
I wonder why this does not have many votes? Is there another way to accomplish this?
Tatsuro Hisamori commented
Good idea! I also want it.
Satoshi Azuma commented
It looks good. And I want this feature about User Defined Functions.