CODEWITHSUNDEEP
sql-serverazure
chuckd
chuckd

Reputation: 14550

Creating a Azure database copy and then loading production data every night into copy

I'd like to create an environment like the one shown in the pic. Are there any good tutorials out there that will help me create a copy of my production database (Sql Server in Azure) and then every night at a specific time load all the data from production into the copy (so I have data to work with in the copy while developing)?

enter image description here

Upvotes: 1

Views: 134

Answers (1)

Admir Tuzović
Admir Tuzović

Reputation: 11177

There are several options that you can use.

Please check this blog post and look under option 2. in particular.

You could set when will this be executed by using Azure Scheduler service that would run your Azure WebJob at the midnight. Azure WebJob would execute "CREATE DATABASE AS COPY OF" command.

Upvotes: 2

Related Questions