UnpackDacPac

Unpack DAC Package .NET Tool

Extracts dacpac and generates deployment script to target folder without need for actual database running.

Install

dotnet tool install --global UnpackDacPac

Usage

unpackdacpac unpack <dacPacPath> <outputPath> [OPTIONS]

Example

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

Will in TargetPath result in a files

• DacMetadata.xml
• Deploy.sql - generated deployment script
• model.sql - formated sql
• model.xml
• Origin.xml
• postdeploy.sql if exists

unpack Options

-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