Update Azure App Service Application Settings to point to Secondary Database without restarting the service

Question

I have an Azure App Service pointing to Azure SQL DB1 and I need to switch/replace Azure SQL DB1 with Azure SQL DB2 and vice versa. To do that, I have a powershell script which updates the application setting with new KeyVault Secret to point to alternate DB and route Traffic to that DB. And, this has to be changed periodically i.e., every time data transfer happens from On-Prem to Cloud DB, I update the AAP settings to point to this DB, which had the recent data from on-prem system.
Yes, I was able to implement this requirement but this involves an Azure App Service restart to reflect the changes made to application settings on to the service.
I need help to perform this action and make changes reflect on to the service **

• without restart

**.

Answer 1

It is not possible to modify the application settings and have them take effect without a restart. You would have to use another mechanism for storing your settings. There's a good thread on Stack Overflow about this with some options that you could consider. https://stackoverflow.com/questions/43481926/change-an-azure-app-setting-using-the-portal-without-a-restart