Hi,
Our scenario is that we have a production database and associated website. The database is a linked resource in our Azure website configuration.
We also have an identical configuration for our staging environment.
As part of our pre-release testing, we would like to copy the production database to the staging database and do testing on our web application in a staging environment. Up until last year, we used to do this by restoring a BACPAC of our production database over the top of the staging database - unfortunately this is now not possible with the new point-in-time restore functionality.
I have seen some posts that recommend deleting the staging database, and then use the Db copy functionality (or a simple BACPAC import). I am hesitant to do this, however, as I am unsure whether this will affect the website this database is associated with (ie remember its a linked resource). I am also unsure of whether all my monitoring, webjobs, configuration, scaling, etc already setup for my staging database will be preserved if I delete and recreate the db.
My question is what is the recommended way of doing this now?
Thanks,
Steve
- Edited by Steve Tapley 23 hours 30 minutes ago