Created
January 22, 2015 13:14
-
-
Save troyhunt/9e1c5094a6eef536804c to your computer and use it in GitHub Desktop.
This one removes all the components I normally create for an Azure website
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Input params | |
$projectName = "TroyPSTest" | |
# Constants | |
$dbServerName = "snyb5o1pxk" | |
$dbServerLogin = "troyhunt" | |
$dbServerPassword = "P@ssw0rd" | |
$apiVersion = "2014-04-01" | |
# Computed vars | |
$dbName = $projectName + "Db" | |
$dbLogin = $dbName + "Login" | |
# Switch over to the resource manager | |
Switch-AzureMode AzureResourceManager | |
# Remove the tag from the website | |
$p = Get-AzureResource -Name $projectName -ResourceGroupName $webResourceGroup -ResourceType Microsoft.Web/sites -ApiVersion $apiVersion | |
Set-AzureResource -Name $projectName -ResourceGroupName $webResourceGroup -ResourceType Microsoft.Web/sites -ApiVersion $apiVersion -PropertyObject $p.Properties -Tags @{ } | |
# Remove the tag from the DB | |
Set-AzureResource -Name $dbName -ResourceGroupName $dbResourceGroup -ParentResource servers/$dbServerName -ResourceType Microsoft.Sql/servers/databases -ApiVersion $apiVersion -Tags @{ } | |
# Delete the tag (if you try to only delete, it may still be attached to resources even if you've already deleted THEM!) | |
Remove-AzureTag -Name Project -Value $projectName -Force | |
# Make sure we kick off in service management mode | |
Switch-AzureMode AzureServiceManagement | |
# Delete the website | |
Remove-AzureWebsite $projectName -Force | |
# Delete the database | |
Remove-AzureSqlDatabase -ServerName $dbServerName -DatabaseName $dbName -Force | |
# Delete the SQL login | |
Import-Module SQLPS -DisableNameChecking | |
$conn = New-Object System.Data.SqlClient.SqlConnection | |
$conn.ConnectionString = "Server=tcp:" + $dbServerName + ".database.windows.net;Database=master;User ID=" + $dbServerLogin + ";Password=" + $dbServerPassword + ";" | |
$srv = New-Object "Microsoft.SqlServer.Management.Smo.Server" $conn | |
$srv.Logins[$dbLogin].Drop() |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment