Found 181 packages
An data access component. It provides a library of classes and a tool, using it in .net project can make data accessing more easily.
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.
The Microsoft SQL Server Data-Tier Application Framework (DacFx) is a component which provides application lifecycle services for database development and management for Microsoft SQL Server and Microsoft Azure SQL Databases. DacFx supports various database deployment and management scenarios for SQL Server and Microsoft Azure SQL Databases including extracting/exporting a live database to a DAC package, deploying a DAC package to a new or existing database, and migrating from on-premise SQL Server to Microsoft Azure. This functionality is exposed via the DacFx API. DacFx can target SQL Server 2008, 2008R2, 2012, 2014, 2016, 2017 and Microsoft Azure SQL Databases. This nuget package is a lightweight version of DacFx. If you would like to use the command-line utility SqlPackage.exe for creating and deploying .dacpac and .bacpac packages, please download DacFramework.msi from Microsoft download page.
Provides targets for projects that result into a data-tier application package (DACPAC).
The Microsoft SQL Server Data-Tier Application Framework (DacFx) is a component which provides application lifecycle services for database development and management for Microsoft SQL Server and Microsoft Azure SQL Databases. DacFx supports various database deployment and management scenarios for SQL Server and Microsoft Azure SQL Databases including extracting/exporting a live database to a DAC package, deploying a DAC package to a new or existing database, and migrating from on-premise SQL Server to Microsoft Azure. This functionality is exposed via the DacFx API. DacFx can target SQL Server 2008, 2008R2, 2012, 2014, 2016, 2017 and Microsoft Azure SQL Databases. This nuget package is a lightweight version of DacFx. If you would like to use the command-line utility SqlPackage.exe for creating and deploying .dacpac and .bacpac packages, please download DacFramework.msi from Microsoft download page.
SqlPackage is a command-line utility that automates database development tasks by exposing some of the public Data-Tier Application Framework (DacFx) APIs.
This package contains the SDK for building SQL Database Projects (.sqlproj) in .NET.
This package contains the master.dacpac for Azure SQL Database.
This package contains the master.dacpac for SQL Server 170.
A simple NuGet package that contains the following libraries: - Microsoft.SqlServer.Dac - Microsoft.Data.Tools.Schema.Sql - Microsoft.Data.Tools.Utilities These libraries provide the 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.
Unpack DAC Package .NET Tool - Extracts dacpac and generates deployment script to target folder without need for actual database running.
The Microsoft SQL Server Data-Tier Application Framework (DACFx) is a component which provides application lifecycle services for database development and management for Microsoft SQL Server and Microsoft Azure SQL Databases.
This package includes the System.Device.Dac assembly for .NET nanoFramework C# projects. This package requires a target with System.Device.Dac v100.0.0.6 (checksum 0x02B3E860).
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.
DacFX Package, Contens from SQL Server 11.0
Mainframe UI toolkit for unsuspecting Console Applications.
This package contains the msdb.dacpac for SQL Server 170.
Dacs7 (Data Access S7) is a library to communicate with a Siemens S7 and TIA PLC.
# 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)