XenDesktop 7 Move Database

Unfortunately once again the documentation provided by Citrix on moving databases from one SQL Server to another is incomplete. The documentation provided here: http://support.citrix.com/article/CTX140319 misses out the configuration of one of the services.

The listing misses out the configuration of the Citrix Analytics Service. In my environment this meant that after the reboot of the service, it tried to do a license server upgrade (I forgot to take a screenshot).

Secondly, the PowerShell that is supplied on the site removes the DB configuration for the MonitorDBConnection and LogDBConnection before removing the configuration from the DataStore of the respective services. This causes an error when running the commands in the order that they list.

My corrected version is below. This assumes that the database has already been moved to the new SQL server and the necessary logins created.

This script must be run elevated and needs to be run on all XenDesktop servers.

21 May 2017 – Updated script to support new services in XenDesktop 7.13, with backwards compatibility. Also prompts you to confirm that the new connection string is correct before continuing.

$OldSQLServer = "OLDSQLSERVER"
$NewSQLServer = "NEWSQLSERVER"

Write-Host "Adding Citrix SnapIns" -ForegroundColor Black -BackgroundColor Yellow
Add-PSSnapin Citrix* -ErrorAction Stop

# Test that all brokers are the same version
if ((Get-BrokerController | Select-Object ControllerVersion -Unique | Measure).Count -ne 1) {
    Write-Error "Multiple delivery controller versions found. Recommended to have the same version throughout before upgrading"
    break
}
[int]$Version = (Get-BrokerController | Select-Object -ExpandProperty ControllerVersion -Unique).Split(".")[1]

Write-Host "Stopping Logging" -ForegroundColor Black -BackgroundColor Yellow
Set-LogSite -State "Disabled"

Write-Host "Updating Connection String" -ForegroundColor Black -BackgroundColor Yellow
$ConnStr = Get-ConfigDBConnection
Write-Host "Old Connection String: $ConnStr"
$ConnStr = $ConnStr.Replace($OldSQLServer,$NewSQLServer)
Write-Host "New Connection String: $ConnStr"

if ([String]::IsNullOrWhiteSpace($Connstr)) {
    Write-Error "New connection string appears to be empty. Unable to proceed"
    break
}

$PromptTitle = "Confirm New Connection String"
$PromptMessage = "Is the new connection string shown above correct?"
$PromptYes = New-Object System.Management.Automation.Host.ChoiceDescription "&Yes", "Change the Database Connection."
$PromptNo = New-Object System.Management.Automation.Host.ChoiceDescription "&No", "Stop! This connection string is wrong!"
$PromptOptions = [System.Management.Automation.Host.ChoiceDescription[]]($PromptNo, $PromptYes)
$Result = $Host.UI.PromptForChoice($PromptTitle, $PromptMessage, $PromptOptions, 0) 
if ($Result -ne 1) { return }

# Clear error history, we can then check it at the end. 
$Error.Clear()

Write-Host "Clearing all current DB Connections" -ForegroundColor Black -BackgroundColor Yellow
Set-ConfigDBConnection -DBConnection $null
if ([int]$Version -ge 6) { Set-AnalyticsDBConnection -DBConnection $null }
if ([int]$Version -ge 8) { Set-AppLibDBConnection -DBConnection $null }
if ([int]$Version -ge 11) { Set-OrchDBConnection -DBConnection $null }
if ([int]$Version -ge 11) { Set-TrustDBConnection -DBConnection $null }
Set-HypDBConnection -DBConnection $null
Set-ProvDBConnection -DBConnection $null
Set-BrokerDBConnection -DBConnection $null
Set-AcctDBConnection -DBConnection $null
Set-EnvTestDBConnection -DBConnection $null
Set-SfDBConnection -DBConnection $null
Set-MonitorDBConnection -DataStore Monitor -DBConnection $null
Set-MonitorDBConnection -DBConnection $null
Set-LogDBConnection -DataStore Logging -DBConnection $null
Set-LogDBConnection -DBConnection $null
Set-AdminDBConnection -DBConnection $null

Write-Host "Configuring new DB Connections" -ForegroundColor Black -BackgroundColor Yellow
Set-AdminDBConnection -DBConnection $ConnStr
Set-ConfigDBConnection -DBConnection $ConnStr
Set-AcctDBConnection -DBConnection $ConnStr
if ([int]$Version -ge 6) { Set-AnalyticsDBConnection -DBConnection $ConnStr }
Set-HypDBConnection -DBConnection $ConnStr
Set-ProvDBConnection -DBConnection $ConnStr
if ([int]$Version -ge 8) { Set-AppLibDBConnection -DBConnection $ConnStr }
if ([int]$Version -ge 11) { Set-OrchDBConnection -DBConnection $ConnStr }
if ([int]$Version -ge 11) { Set-TrustDBConnection -DBConnection $ConnStr }
Set-BrokerDBConnection -DBConnection $ConnStr
Set-EnvTestDBConnection -DBConnection $ConnStr
Set-SfDBConnection -DBConnection $ConnStr
Set-LogDBConnection -DBConnection $ConnStr
Set-LogDBConnection -DataStore Logging -DBConnection $ConnStr
Set-MonitorDBConnection -DBConnection $ConnStr
Set-MonitorDBConnection -DataStore Monitor -DBConnection $ConnStr


Write-Host "Testing new DB Connections..." -ForegroundColor Black -BackgroundColor Yellow
Test-AcctDBConnection -DBConnection $ConnStr
Test-AdminDBConnection -DBConnection $ConnStr
if ($Version -ge 6) { Test-AnalyticsDBConnection -DBConnection $ConnStr }
if ($Version -ge 8) { Test-AppLibDBConnection -DBConnection $ConnStr }
Test-BrokerDBConnection -DBConnection $ConnStr
Test-ConfigDBConnection -DBConnection $ConnStr
Test-EnvTestDBConnection -DBConnection $ConnStr
Test-HypDBConnection -DBConnection $ConnStr
Test-LogDBConnection -DBConnection $ConnStr
Test-MonitorDBConnection -DBConnection $ConnStr
if ($Version -ge 11) { Test-OrchDBConnection -DBConnection $ConnStr }
Test-ProvDBConnection -DBConnection $ConnStr
Test-SfDBConnection -DBConnection $ConnStr
if ($Version -ge 11) { Test-TrustDBConnection -DBConnection $ConnStr }


Write-Host "Re-enabling Logging" -ForegroundColor Black -BackgroundColor Yellow
Set-MonitorConfiguration -DataCollectionEnabled $true
Set-LogSite -State "Enabled"

Write-Host "Get details of all new DB Connection strings"
Get-ConfigDBConnection 
if ([int]$Version -ge 6) { Get-AnalyticsDBConnection  }
if ([int]$Version -ge 8) { Get-AppLibDBConnection  }
if ([int]$Version -ge 11) { Get-OrchDBConnection  }
if ([int]$Version -ge 11) { Get-TrustDBConnection  }
Get-HypDBConnection 
Get-ProvDBConnection 
Get-BrokerDBConnection 
Get-EnvTestDBConnection 
Get-SfDBConnection 
Get-MonitorDBConnection 
Get-MonitorDBConnection -DataStore Monitor 
Get-LogDBConnection -DataStore Logging 
Get-LogDBConnection 
Get-AdminDBConnection 
Get-AcctDBConnection

if ($Error.Count -gt 0) {
    Write-Error "There have been issues changing the database connection. Please check the current connection strings and update any that are incorrect before restarting services"
    break
}

Write-Host "Restarting all Citrix Services..." -ForegroundColor Black -BackgroundColor Yellow
Get-Service Citrix* | Stop-Service -Force
Get-Service Citrix* | Start-Service

1 person found this post useful.

Mark this post as useful.

Unmark this post as useful.