Create Database [X] As Copy Of [Y] In [Tier]
I am currently using a P2 instance for my live system - obviously there are a number of visitors using this site so when I update it I want to be sure it will work. As a result, I will always run the CREATE DATABASE [staging_X] AS COPY OF [Y] and then run scripts / test a release against that.
After a few minutes this is up and running. However, this will create a P2 instance at a General Availability price of around £40! Since it's only me that's using it I could get away with a Web edition or an S1 at a fraction of the price.
It would be good if I could specify the tier that I want the copy to go in. The alternative is to import a backup - which I have had one running for 3 hours and it's still at 5%!
Of course, the alternative would be to not charge for the first day? This would also help with the high costs of backing up databases.
Thanks for the feedback. We are evaluating some changes for Create DB as copy of. I’ll get back to you when I have those details.