UnpackDacPac 2023.11.28.5

Unpack DAC Package .NET 工具

提取 dacpac 并生成部署脚本，无需实际运行的数据库即可针对目标文件夹。

安装

dotnet tool install --global UnpackDacPac

用法

unpackdacpac unpack <dacPacPath> <outputPath> [OPTIONS]

示例

unpackdacpac unpack Source.dacpac TargetPath  --deploy-script-exclude-object-type Users --deploy-script-exclude-object-type Logins --deploy-script-exclude-object-type RoleMembership

在 TargetPath 中将生成以下文件

• DacMetadata.xml
• Deploy.sql - 生成的部署脚本
• model.sql - 格式化的 sql
• model.xml
• Origin.xml
• postdeploy.sql 如果存在

unpack 选项

-h, --help                                                      Prints help information
    --clean-output-path                                         Flag for if output path should be cleaned before
                                                                extraction
    --target-database                                           Target database name used for deploy script, if not
                                                                specified DAC Package name without extension is used
    --deploy-create-new-database                                Flag that specifies whether the existing database will be
                                                                dropped and a new database created before proceeding with
                                                                the actual deployment actions. Acquires single-user mode
                                                                before dropping the existing database (default false)
    --deploy-script-database-options                            Deployment script flag that specifies whether the
                                                                database options in the target database should be updated
                                                                to match the source model (default false)
    --deploy-script-ignore-permissions                          Deployment script flag that specifies whether to exclude
                                                                all permission statements from consideration when
                                                                comparing the source and target model (default false)
    --deploy-script-exclude-object-type <EXCLUDEDOBJECTTYPE>    Deployment script setting to exclude object types