How to replace an readonly Azure SQL Database in deployment
We moved our web application to Azure and I’m trying to create the script for the automated deployment. Currently I’m facing some problems concerning the deployment of the connected Azure SQL database. This database provides data for the application and is only used readonly. The script should replace the contents of the database by the data provided in the repository, while the database resource itself with all its settings should remain untouched.
I’m not sure which way to go or what I should search for. What is the best pratice for this scenario?
Any help is highly appreciated. thanks
The solutions I have found so far are
migration (which we don’t need in this scenario since there is no data to keep on updating the db) or
restoring from a backup (which will result in a new database).
Read more here: Source link
