inogen/deployment/prepare-transfer-connections.ps1

63 lines
2.7 KiB
PowerShell

[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.'