Skip to content

Copy Azure SQL database

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
# Sign-in with CSP account

$TenantId = ''
$SubscriptionId = ''

$PSDefaultParameterValues = @{
  '*-AzureRM*:TenantId' = $TenantId
}

Connect-AzureRmAccount

#DHL APP SERVICE
Set-AzureRmContext -Subscription $SubscriptionId

################################################################################

$ResourceGroupName = ''
$SQLServerName = ''
$SourceDatabaseName = ''
$DestinationDatabaseName = ''

#region Remove existing duplicate
<#
Write-Verbose 'Removing old copy...'
Remove-AzureRmSqlDatabase -ResourceGroupName $ResourceGroupName -ServerName $SQLServerName -DatabaseName $DestinationDatabaseName -Force -ErrorAction SilentlyContinue
#>
#endregion Remove existing duplicate

Write-Verbose 'Start Copy... Please wait ... '
New-AzureRmSqlDatabaseCopy -ResourceGroupName $ResourceGroupName `
-ServerName $SQLServerName `
-DatabaseName $SourceDatabaseName `
-CopyResourceGroupName $ResourceGroupName `
-CopyServerName $SQLServerName `
-CopyDatabaseName $DestinationDatabaseName
Write-Verbose ' !Done! '
#New-BurntToastNotification -Text 'Azure SQL', 'Database copy task completed' -AppLogo "$env:USERPROFILE\Pictures\powershell-1.png"