Ensure you have 7-zip installed, obviously. I adapted this from some other code I found on the internets, but unfortunately I can’t find the original post, so apologies for not giving the original author props.
# Alias for 7-zip
if (-not (test-path "$env:ProgramFiles\7-Zip\7z.exe")) {throw "$env:ProgramFiles\7-Zip\7z.exe needed"}
set-alias sz "$env:ProgramFiles\7-Zip\7z.exe"
$path = "C:\Test\ScriptDB\"
foreach($dir in gci -Path $path | where{$_.PSIsContainer})
{
$zipFile = $path + $dir.Name + ".zip"
sz a -tzip "$zipfile" $dir.FullName
Remove-Item $dir.FullName -Recurse -Force
}
Sql Server Powershell 
Leave a reply to JoeKerr Cancel reply