Import-Module SqlPs
Import-Module Az

$Date = (Get-Date).ToString("yyyMMdd")
$FileName = "$Date.bak"
$CompressedFile = "$Date.zip"
$StorageAccountName = "solusimanufaktur"
$StorageAccountKey = "tqede6qD1Yk7jIqzFMpG/bzWkWMVUguAOCuwj/3AeArCQP+YOEIu1ldqR+cTDH7x9Wu0/OjmR182CQXJWiiNbA=="
$ContainerName = "demokb"
$InstanceName = ".\MSSQLSERVER"
$DatabaseName = "KB"
$DbUsername = "sa"
$DbPassword = "P@ssw0rd12345"
$FilePath = "C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Backup\$FileName"
$CompressedFilePath = "C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Backup\$CompressedFile"

Write-Host "Connecting To Azure"
Import-AzContext -Path C:\Users\smart\Documents\AzureAuth.json
Select-AzSubscription -SubscriptionName "Pay-As-You-Go"
$ctx = New-AzStorageContext -StorageAccountName $StorageAccountName -StorageAccountKey $StorageAccountKey

$dbPassword = ConvertTo-SecureString $DbPassword -AsPlainText -Force
$dbCredential = New-Object System.Management.Automation.PSCredential ($DbUsername, $dbPassword)
Write-Host "Backup database KB, store to file $FileName"
Backup-SqlDatabase -ServerInstance $InstanceName -Database $DatabaseName -BackupFile $FilePath -SqlCredential $dbCredential

Write-Host "Compressing backup file to $CompressedFile"
Compress-Archive $FilePath $CompressedFilePath

Write-Host "Uploading backup file"
Set-AzStorageBlobContent -Container $ContainerName -File $CompressedFilePath -Blob $CompressedFile -Context $ctx -Force

Write-Host "Removing temporary file"
Remove-Item $FilePath
Remove-Item $CompressedFilePath