Pipelines/Steps/Install/OnPrem/Sitecore/Uninstall/Delete-SQLDatabasesAndLogins.ps1
|
$ErrorActionPreference = "Stop" $prefix = $SAFConfiguration.prefix $sqlServer = $SAFConfiguration.sql.serverName $sqlUser = $SAFConfiguration.sql.adminUsername $sqlAdminPassword = $SAFConfiguration.sql.adminPassword $dbs = @("$($prefix)_Core", "$($prefix)_EXM.Master", "$($prefix)_ExperienceForms", "$($prefix)_Master", "$($prefix)_Processing.Tasks", "$($prefix)_Web", "$($prefix)_MarketingAutomation", "$($prefix)_Messaging", "$($prefix)_Processing.Pools", "$($prefix)_ProcessingEngineStorage", "$($prefix)_ProcessingEngineTasks", "$($prefix)_ReferenceData", "$($prefix)_Reporting", "$($prefix)_Xdb.Collection.Shard0", "$($prefix)_Xdb.Collection.Shard1", "$($prefix)_Xdb.Collection.ShardMapManager") if (($null -eq $SAFConfiguration.sql.customDatabases) -or ($SAFConfiguration.sql.customDatabases.Count -lt 1)) { Write-Output "No custom databases to delete." } else { foreach ($db in $SAFConfiguration.sql.customDatabases) { $dbs += $db.dbName } } DeleteDatabases -SqlServer $sqlServer -Databases $dbs -Username $sqlUser -Password $sqlAdminPassword DeleteLogin -SqlServer $sqlServer -SqlLogin "$($prefix)_collectionuser" -Username $sqlUser -Password $sqlAdminPassword |