PS script to compute a new file hash for a modified BACPAC

computeFileHash.ps1

param (
    [string]$fileName = "model.xml"
 )

If (Test-Path $fileName) {
	$modelXmlPath = Resolve-Path $fileName
} else {
    Write-Host ("File " + (Resolve-Path .) + "\" + $fileName + " does not exist");
	exit;
}

Write-Host ("Creating hash for file: " + $modelXmlPath)

$hasher = [System.Security.Cryptography.HashAlgorithm]::Create("System.Security.Cryptography.SHA256CryptoServiceProvider") 

$fileStream = new-object System.IO.FileStream ` -ArgumentList @($modelXmlPath, [System.IO.FileMode]::Open) 

$hash = $hasher.ComputeHash($fileStream) 

$hashString = "" 

Foreach ($b in $hash) { $hashString += $b.ToString("X2") } 

$fileStream.Close() 

Write-Host ("Hash is: " + $hashString)

Original script from: https://techcommunity.microsoft.com/t5/Azure-Database-Support-Blog/Editing-a-bacpac-file/ba-p/368931 modified to accept a -fileName parameter and resolve it properly, even from the uncompressed BACPAC package directory.