[CmdletBinding()] param( [Parameter(Mandatory = $true)][ValidateNotNullOrEmpty()][string]$SourceServer, [Parameter(Mandatory = $true)][ValidateNotNullOrEmpty()][string]$SourceDatabase, [Parameter(Mandatory = $true)][ValidateNotNullOrEmpty()][string]$SourceUser, [Parameter(Mandatory = $true)][ValidateNotNullOrEmpty()][string]$TargetUser, [switch]$TrustSourceCertificate, [switch]$TrustTargetCertificate ) $ErrorActionPreference = 'Stop' $settings = Get-Content -LiteralPath (Join-Path $PSScriptRoot 'backend\appsettings.Production.json') -Raw | ConvertFrom-Json $servers = @($settings.TargetDatabaseGuard.AllowedServers) $databases = @($settings.TargetDatabaseGuard.AllowedDatabases) if ($servers.Count -ne 1 -or $databases.Count -ne 1 -or [string]::IsNullOrWhiteSpace($servers[0]) -or [string]::IsNullOrWhiteSpace($databases[0])) { throw 'Set exactly one target server and database in backend/appsettings.Production.json.' } if ($SourceServer -ieq $servers[0] -and $SourceDatabase -ieq $databases[0]) { throw 'Source and destination must be different databases.' } function Read-SqlPassword([string]$prompt) { $secret = Read-Host $prompt -AsSecureString $pointer = [Runtime.InteropServices.Marshal]::SecureStringToBSTR($secret) try { [Runtime.InteropServices.Marshal]::PtrToStringBSTR($pointer) } finally { [Runtime.InteropServices.Marshal]::ZeroFreeBSTR($pointer) $secret = $null } } $sourcePassword = Read-SqlPassword 'Old database password' try { $source = New-Object System.Data.SqlClient.SqlConnectionStringBuilder $source['Data Source'] = $SourceServer $source['Initial Catalog'] = $SourceDatabase $source['User ID'] = $SourceUser $source['Password'] = $sourcePassword $source['ApplicationIntent'] = 'ReadOnly' $source['Encrypt'] = $true $source['TrustServerCertificate'] = [bool]$TrustSourceCertificate $env:INOGEN_SOURCE_READONLY_CONNECTION = $source.ConnectionString } finally { $sourcePassword = $null; $source = $null } $targetPassword = Read-SqlPassword 'New database password' try { $target = New-Object System.Data.SqlClient.SqlConnectionStringBuilder $target['Data Source'] = [string]$servers[0] $target['Initial Catalog'] = [string]$databases[0] $target['User ID'] = $TargetUser $target['Password'] = $targetPassword $target['Encrypt'] = $true $target['TrustServerCertificate'] = [bool]$TrustTargetCertificate $env:ConnectionStrings__TargetDatabase = $target.ConnectionString } finally { $targetPassword = $null; $target = $null } Write-Host "Source: $SourceServer/$SourceDatabase" Write-Host "Target: $($servers[0])/$($databases[0])" Write-Host 'Both connections are ready in this PowerShell session.'