43 packages tagged with “DacPac”
The Microsoft SQL Server Data-Tier Application Framework (DacFx) is a .NET library which provides application lifecycle services for database development and management for Microsoft SQL databases. DacFx supports various database deployment and management scenarios, including extracting / exporting a live database to a DAC package, deploying a DAC package to a new or existing database, and migrating from on-premises to Microsoft Azure. DacFx can target all supported versions of SQL Server, as well as Microsoft Azure SQL and SQL in Fabric. If you would like to use DacFx functionality from the command-line for creating and deploying .dacpac and .bacpac packages, please use the [SqlPackage](https://www.nuget.org/packages/Microsoft.SqlPackage) CLI as a dotnet tool or downloadable exe. Learn more about SqlPackage from http://aka.ms/sqlpackage.
Provides targets for projects that result into a data-tier application package (DACPAC).
SqlPackage is a command-line utility that automates database development tasks by exposing some of the public Data-Tier Application Framework (DacFx) APIs.
Templates that can be used to scaffold new MSBuild.Sdk.SqlProj projects.
This package contains the master.dacpac for Azure SQL Database.
This package contains the master.dacpac for SQL Server 170.
Unpack DAC Package .NET Tool - Extracts dacpac and generates deployment script to target folder without need for actual database running.
Cake addin that extends Cake for creating and deploying SQL Server databases and DACPAC packages.
Enables reverse engineering an EF Core model from a data-tier application package (DACPAC).
Dac Package for Microsoft SQL Server 2014. This NuGet Package contains the following libraries: - Microsoft.Data.Tools.Contracts.dll - Microsoft.Data.Tools.Schema.Sql.dll - Microsoft.Data.Tools.Schema.Tasks.Sql.dll - Microsoft.Data.Tools.Schema.Utilities.Sql.dll - Microsoft.Data.Tools.Utilities.dll - Microsoft.SqlServer.Dac.dll - Microsoft.SqlServer.Dac.Extensions.dll This package provides the libraries needed to perform operations on DACPAC and BACPAC packages. These files are governed by Microsoft's license terms. The package is provided under the MIT License.
This package contains the msdb.dacpac for SQL Server 170.
This namespace provides classes you can use in your code to perform operations on DACPAC and BACPAC packages. These packages can be extracted and exported from existing databases or used to deploy and import new databases. DAPCAC packages can also be used to upgrade an existing database.
This package contains the master.dacpac for SQL Azure Synapse Analytics.
This package contains the system database objects for SQL database in Microsoft Fabric. https://aka.ms/sqlproj-package-ref
Provides a .NET tool to deploy SQL Server instances and instance configuration across multiple SQL servers.
Extends a .NET project such that it can establish ProjectReferences to SSDT projects, including importing the target projects generated DACPAC output into the output of the augmented project.
# 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 8.0+ 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)
Package Description
This package contains the master.dacpac for SQL Azure Synapse Serverless.
Helper to deploy your SQL Server DataTools .dacpac files in code.
A simple framework for running sql tests against a temprary localdb instance, optionally deploying a dacpac, using a nice fluent c# api
Deploy your database without data lose with dacpac. This package cannot be installed using Visual Studio. Review project website first.
Library for merging a Data-tier Application Package file (dacpac) with and existing database
This package contains the master.dacpac for Microsoft Fabric DW.
Unofficial package containing SqlPackage.exe command-line utility, from SQL Server 13.0
A simple framework for running sql tests against a temprary localdb instance, optionally deploying a dacpac, using a nice fluent c# api. This package contains some xUnit specific assertions.
Necessary libraries for custom DeploymentPlanModifier implementation.
A simple framework for running sql tests against a temprary localdb instance, optionally deploying a dacpac, using a nice fluent c# api. This package contains some NUnit specific assertions.