Start_K2_setup_DB_connection.sql

$newConnection = "Data Source=DLX;Initial Catalog=K2;Integrated Security=True"

$installKey = Get-ItemProperty "HKLM:\SOFTWARE\SourceCode\blackpearl\blackpearl Core"
$configPath = $installKey.InstallDir + "Setup\Configuration.config"

$xml = New-Object XML
$xml.Load($configPath)

$connectionNode = $xml.configuration.configurationdatabase.add | Where-Object { $_.key -eq 'connectionString' } 
$connectionNode.value = $newConnection

$xml.Save($configPath)

$setupExe = $installKey.InstallDir + "Setup\Setup.exe"
Start-Process $setupExe