Dacpac.Tool

Release 3.0.512

# 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](https://docs.microsoft.com/en-us/sql/relational-databases/data-tier-applications/data-tier-applications?view=sql-server-2017)</sup> ### Requirements 1. .NET Core 2.1+ runtime installed ### Publish .dacpac with .Net tool #### Install the Dacpac.Tool package ```powershell 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) ```powershell dotnet dacpac publish --dacpath=C:\artifact\db\ --server=mydatabase.server.contoso.com --databasenames='client1;client2;client3;client4' ``` * Specific User authentication ```powershell 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](https://docs.microsoft.com/en-us/dotnet/api/microsoft.sqlserver.dac.dacdeployoptions?redirectedfrom=MSDN&view=sql-dacfx-140.3881.1)

Homepage Repository NuGet C# Download

Keywords
sqlserver, dacpac, deploy, ci, dotnet-tool, dacpac-packages, mssql, sql-server, tool
License
MIT
Install
Install-Package Dacpac.Tool -Version 3.0.512

Documentation

Badge

PT-BR

What is?

The SQLServer Deploy is a set of scripts that are able to perform the publication of the structure of your database (MS SQL Server) based on the selected .dacpac file.

How it works?

The executed script searches for a file that matches the pattern entered, connects to the database using the connection string, instantiates a class, from the SDDT package, configures the execution of the publication, and executes deploy.

Deploy one database by task

alt text

Deploy multiple database by task on same server

alt text

Requirements:

For this task to run the "Agent" running server must have installed SQL Server Data Tools in the directory C:\Program Files (x86)\Microsoft SQL Server\120\DAC\bin\Microsoft.SqlServer.Dac.dll

Link para download

See more

.Net Tool

To collaborate:

logo

Stats

Dependencies
0
Dependent packages
0
Dependent repositories
0
Total releases
12
Latest release
First release
Stars
1
Forks
0
Watchers
0
Contributors
1
Repository size
4.96 MB
SourceRank
8

Development practices

Source repo 2FA enabled
TEXT!
Package manager 2FA enabled
TEXT!
Is security responsive
TEXT!
Dependencies are managed
TEXT!
Issue-free release available
TEXT!
Succession plan available
TEXT!
Package manager 2FA enabled
TEXT!

The Tidelift Subscription provides access to a continuously curated stream of human-researched and maintainer-verified data on open source packages and their licenses, releases, vulnerabilities, and development practices.

Learn more →

Releases

3.0.512
2.3.0.498
1.0.375
1.0.386
1.0.388
1.1.493
1.0.371
2.1.0.494
2.2.0.495
2.2.0.497
See all 12 releases

Contributors

Gustavo Américo


See all contributors

Something wrong with this page? Make a suggestion

Export .ABOUT file for this package

Last synced: 2023-02-09 15:05:15 UTC

Login to resync this project