用powershell将dacpac转换为数据库对象的文件夹结构

# 导入SqlPackage.exe工具路径
$SqlPackagePath = "C:\Program Files (x86)\Microsoft Visual Studio\2019\Enterprise\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\150"
$SqlPackageExe = Join-Path $SqlPackagePath "SqlPackage.exe"

# 设置输入和输出路径
$DacpacPath = "C:\path\to\your\input.dacpac"
$OutputFolderPath = "C:\path\to\your\output\folder"

# 创建输出文件夹
New-Item -ItemType Directory -Force -Path $OutputFolderPath

# 使用SqlPackage.exe将dacpac转换为文件夹结构
& $SqlPackageExe /a:Extract /ssn:"Data Source=YourServer;Initial Catalog=YourDatabase;Integrated Security=True" /tf:$DacpacPath /df:$OutputFolderPath

Write-Host "转换完成！"