UnpackDacPac 2025.1.21.15

dotnet tool install --global UnpackDacPac --version 2025.1.21.15                
This package contains a .NET tool you can call from the shell/command line.
dotnet new tool-manifest # if you are setting up this repo
dotnet tool install --local UnpackDacPac --version 2025.1.21.15                
This package contains a .NET tool you can call from the shell/command line.
#tool dotnet:?package=UnpackDacPac&version=2025.1.21.15                
nuke :add-package UnpackDacPac --version 2025.1.21.15                

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
Product Compatible and additional computed target framework versions.
.NET net8.0 is compatible.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed.  net9.0 is compatible.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

This package has no dependencies.

Version Downloads Last updated
2025.1.21.15 2,177 1/21/2025
2025.1.19.13 531 1/19/2025
2024.11.23.11 11,597 11/23/2024
2024.11.4.9 4,703 11/4/2024
2024.9.21.7 9,609 9/21/2024
2023.11.28.5 53,219 11/28/2023
2023.10.23.3 80,789 10/23/2023
2023.10.20.1 482 10/20/2023