replace-server-in-cbs.ps1

<#
	Peter Tyrrell, Andornot

	Replaces old sql server name with new in textbase binary *.cbs file.

	Note: Uses PowerShell Core syntax. See comments for Windows PowerShell.
	Note: Server names of different lengths corrupt the file.
#>

param (
	[string]$file = "D:\temp\ampas\backups\AAtrans.cbs",
	[string]$find = "SERVER80",
	[string]$replace = "P3SQL264"
)

$hexFind = ($find | Format-Hex).HexBytes
$hexReplace = ($replace | Format-Hex).HexBytes

# In *Windows PowerShell*, replace `-AsByteStream` with `-Encoding Byte`
$byteArray = get-content $file -Raw -AsByteStream
$byteString = $byteArray.ForEach('ToString', 'X') -join ' '
echo "Replacing `'$find`' with `'$replace`' in $file"
$byteString = $byteString -replace $('\b' + $hexFind + '\b(.*)'), $($hexReplace + '$1')
# In *Windows PowerShell* use `-Encoding Byte` instead of `-AsByteStream`.
[byte[]] $newByteArray = -split $byteString -replace '^', '0x'
set-content $file -AsByteStream -Value $newByteArray