Copy all blobs from a StorageAccount container to another.
The only service which is mandatory (besides two Azure SQL Servers) is Azure Storage Account, on which bacpac files will be stored. It's up to you how you will configure this storage, as there aren't any specific requirement.
Since PowerShell Gallery is involved, you need to have PowerShellGet installed. Instructions how to install PowerShellGet (https://docs.microsoft.com/en-us/powershell/scripting/gallery/installing-psget?view=powershell-7.1).
You need to open the firewall so that the script has access to communicate with the Sql Server.
A blob container with the name 'db-backups' in the StorageAccount where the BACPAC file will be stored.
Account/Service Prinicipal under which script will work should have proper permission (Contributor) assigned to storage account.
- First open up PowerShell prompt as an administrator.
- Start type
Set-ExecutionPolicy -Scope CurrentUser UnrestrictedThis is to remove warnings if your environment does not trust these scripts.
3. Then install the EpinovaAzureToolBucket.
Install-Module EpinovaAzureToolBucket -Scope CurrentUser -Force- Add the code below and make the changes needed to fit your context.
$SubscriptionId = "e8xxx180-9xxf-4xx4-axx7-3xxxffxx7fxx"
$SourceResourceGroupName = "rg-ove-1231hjkjia-dev"
$SourceStorageAccountName = "stove1231hjkjiadev"
$SourceContainerName = "mysitemedia"
$DestinationResourceGroupName = "rg-ove-1231hjkjia-prep"
$DestinationStorageAccountName = "stove1231hjkjiaprep"
$DestinationContainerName = "mysitemedia"
$CleanBeforeCopy = $true
Copy-Blobs -SubscriptionId $SubscriptionId -SourceResourceGroupName $SourceResourceGroupName -SourceStorageAccountName $SourceStorageAccountName -SourceContainerName $SourceContainerName -DestinationResourceGroupName $DestinationResourceGroupName -DestinationStorageAccountName $DestinationStorageAccountName -DestinationContainerName $DestinationContainerName -CleanBeforeCopy $CleanBeforeCopy