Updating External Database DevOps via Lifetime
Application Type


We wrote an application using an external database. The deployment of our production environment on on-prem in Azure and the external database is an Azure SQL database.

Everything is working perfectly, except that every time we deploy a new version, we have to manually run the scripts on the database before deploying the production system.

We intend to hand the deployment of the production environment over to the vendor of the Azure PaaS solutions, but will require much more insight into this from some knowledgeable people.

Is there a DevOps path we can follow that will allow the external database(s) (we have various apps) and the QA to Production Lifetime deployment of specific applications be done by the Azure Administrator without having to execute manual scripts on databases or maybe even access lifetime if he doesn't need access?

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.