UnpackDacPac 2024.9.21.7

dotnet tool install --global UnpackDacPac --version 2024.9.21.7                
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 2024.9.21.7                
This package contains a .NET tool you can call from the shell/command line.
#tool dotnet:?package=UnpackDacPac&version=2024.9.21.7                
nuke :add-package UnpackDacPac --version 2024.9.21.7                

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 net6.0 is compatible.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  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. 
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
2024.9.21.7 8,479 9/21/2024
2023.11.28.5 53,207 11/28/2023
2023.10.23.3 60,863 10/23/2023
2023.10.20.1 467 10/20/2023