Advanced Option: Update the Configuration with PowerShell

Advanced users and IT administrators can update the configuration file efficiently with a PowerShell script. This script:

           
• Updates the configuration for the Windows account under which the script is executed.
           
• Creates a timestamped backup copy before making changes.
           
• Updates only the DBPort and DBName settings.
           
• Verifies both settings exist before saving.
           
• Automatically restores the backup if the update fails.
           
• Is compatible with Windows PowerShell 5.1.
       

Important: User Context

The script targets the $env:LOCALAPPDATA environment variable, which points directly to the profile of the account running the PowerShell session. Therefore, the script must be run under the Windows account that will use Trail Blazer. It does not require administrative privileges under normal conditions.

Do not use "Run as different user" with an unrelated administrator account, or it will modify the administrator's profile instead of the user's profile.

PowerShell Script

Save the following code block exactly as Update-TrailBlazerConfig.ps1:

#requires -Version 5.1<#.SYNOPSISUpdates the Trail Blazer database port and database name for theWindows account under which the script is run..DESCRIPTIONLocates TrailBlazer.config in the current account's Local AppDatafolder, creates a timestamped backup, and updates the DBPort andDBName XML settings.Run this script under the Windows account that will use Trail Blazer.#>[CmdletBinding()]param (    [Parameter(Mandatory = $true)]    [ValidateNotNullOrEmpty()]    [string]$DBName,    [Parameter()]    [ValidateSet('554', '5356', '51433')]    [string]$DBPort = '554')$ConfigPath = Join-Path $env:LOCALAPPDATA 'TrailBlazer\TrailBlazer.config'if (-not (Test-Path -LiteralPath $ConfigPath -PathType Leaf)) {    throw "The Trail Blazer configuration file was not found: $ConfigPath"}$Timestamp = Get-Date -Format 'yyyyMMdd-HHmmss'$BackupPath = "$ConfigPath.$Timestamp.bak"Copy-Item -LiteralPath $ConfigPath -Destination $BackupPath -Force -ErrorAction Stoptry {    [xml]$ConfigXml = Get-Content -LiteralPath $ConfigPath -Raw -ErrorAction Stop    $DBPortNode = $ConfigXml.SelectSingleNode('/configuration/userSettings/DBPort')    $DBNameNode = $ConfigXml.SelectSingleNode('/configuration/userSettings/DBName')    if ($null -eq $DBPortNode) {        throw 'The DBPort setting was not found in the configuration file.'    }    if ($null -eq $DBNameNode) {        throw 'The DBName setting was not found in the configuration file.'    }    $OldDBPort = $DBPortNode.InnerText    $OldDBName = $DBNameNode.InnerText    $DBPortNode.InnerText = $DBPort    $DBNameNode.InnerText = $DBName    $Encoding = New-Object System.Text.UTF8Encoding($false)    $WriterSettings = New-Object System.Xml.XmlWriterSettings    $WriterSettings.Encoding = $Encoding    $WriterSettings.Indent = $false    $WriterSettings.OmitXmlDeclaration = $false    $Writer = [System.Xml.XmlWriter]::Create($ConfigPath, $WriterSettings)    try {        $ConfigXml.Save($Writer)    }    finally {        $Writer.Dispose()    }    Write-Host ''    Write-Host 'Trail Blazer configuration updated successfully.' -ForegroundColor Green    Write-Host "Configuration file: $ConfigPath"    Write-Host "DBPort: $OldDBPort -> $DBPort"    Write-Host "DBName: $OldDBName -> $DBName"    Write-Host "Backup: $BackupPath"}catch {    Copy-Item -LiteralPath $BackupPath -Destination $ConfigPath -Force -ErrorAction SilentlyContinue    throw "The configuration could not be updated. The original file was restored. $($_.Exception.Message)"}

Running the Script

Under the Windows account that will use Trail Blazer:

           
1. Close Trail Blazer.
           
2. Open Windows PowerShell.
           
3. Change directories (cd) to the folder containing the script.
           
4. Execute the script using the following command framework:
       

Set-ExecutionPolicy -Scope Process -ExecutionPolicy Bypass -Force.\Update-TrailBlazerConfig.ps1 -DBName 'YOUR_ORGANIZATION_DATABASE_NAME' -DBPort '554'