Dacpac.Tool 1.0.373

There is a newer version of this package available.
See the version list below for details.
The owner has unlisted this package. This could mean that the package is deprecated, has security vulnerabilities or shouldn't be used anymore.
dotnet tool install --global Dacpac.Tool --version 1.0.373
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 Dacpac.Tool --version 1.0.373
This package contains a .NET tool you can call from the shell/command line.
#tool dotnet:?package=Dacpac.Tool&version=1.0.373
nuke :add-package Dacpac.Tool --version 1.0.373

How use

Use .NetCore tool for publish .dacpac file

What's .dacpac

A data-tier application (DAC) is a logical database management entity that defines all SQL Server objects - such as tables, views, and instance objects - associated with a user's database. It is a self-contained unit of SQL Server database deployment that enables data-tier developers and DBAs to package SQL Server objects into a portable artifact called a DAC package, or .dacpac file. <sup>See more</sup>

Requirements

  1. .NET Core 2.1+ runtime installed

Publish .dacpac with .Net tool

Install the Dacpac.Tool package
 dotnet tool install --global Dacpac.Tool
Run tool only with the required parameters
  1. Use case
    Multi tenant database, your have same schema for multiple client on database server
  • Windows autentication (SSPI)

dotnet dacpac publish --dacpath=C:\artifact\db\ --server=mydatabase.server.contoso.com --databasenames='client1;client2;client3;client4'
  • Specific User authentication
dotnet dacpac publish --dacpath=C:\artifact\db\ --server=mydatabase.server.contoso.com --databasenames='client1;client2;client3;client4' --userId=useWithPersmissionForUpdate --password=123455

  • Parameters
Name Description Default
dacpath Directory where the dacpac file is stored Directory that the tool is running
databasenames The names of databases that need to be updated It's requerid not have default
namenattern Pattern for search file *.dacpac
UseSspi Indicates that the windows user should be used true
userId Database user <sub>Need permissions for schema change</sub> carioca
password The password from 'userid' IFromBrazilian

See all parameters

Product Compatible and additional computed target framework versions.
.NET net5.0 was computed.  net5.0-windows was computed.  net6.0 was computed.  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 was computed.  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. 
.NET Core netcoreapp2.2 is compatible.  netcoreapp3.0 was computed.  netcoreapp3.1 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
3.0.512 2,111 2/9/2023
2.3.0.498 5,361 8/18/2021