nugetsqltools

The current data provider for SQL Server and Azure SQL databases. This has replaced System.Data.SqlClient. These classes provide access to SQL and encapsulate database-specific protocols, including tabular data stream (TDS). Commonly Used Types: Microsoft.Data.SqlClient.SqlConnection Microsoft.Data.SqlClient.SqlException Microsoft.Data.SqlClient.SqlParameter Microsoft.Data.SqlClient.SqlDataReader Microsoft.Data.SqlClient.SqlCommand Microsoft.Data.SqlClient.SqlTransaction Microsoft.Data.SqlClient.SqlParameterCollection Microsoft.Data.SqlClient.SqlClientFactory When using NuGet 3.x this package requires at least version 3.4.

Internal implementation package not meant for direct consumption. Please do not reference directly. When using NuGet 3.x this package requires at least version 3.4.

This is a helper library for Microsoft.Data.SqlClient enabling cross framework support of UDT types. Available Types: Microsoft.SqlServer.Server.IBinarySerializer Microsoft.SqlServer.Server.InvalidUdtException Microsoft.SqlServer.Server.SqlFacetAttribute Microsoft.SqlServer.Server.SqlFunctionAttribute Microsoft.SqlServer.Server.SqlMethodAttribute Microsoft.SqlServer.Server.SqlUserDefinedAggregateAttribute Microsoft.SqlServer.Server.SqlUserDefinedTypeAttribute Microsoft.SqlServer.Server.DataAccessKind Microsoft.SqlServer.Server.SystemDataAccessKind Microsoft.SqlServer.Server.Format

Internal implementation package not meant for direct consumption. Please do not reference directly. When using NuGet 3.x this package requires at least version 3.4.

Microsoft.Data.SqlClient Internal Logging - ETW EventSource for SqlClient tracing and diagnostics. This package is for internal use by other Microsoft.Data.SqlClient packages only and should not be referenced directly by application code.

Microsoft.Data.SqlClient Extensions Abstractions

The SQL Server Management Objects (SMO) Framework is a set of objects designed for programmatic management of Microsoft SQL Server and Microsoft Azure SQL Database.

The Microsoft SQL ScriptDOM library provides parsing and analysis capabilities for management and development of TSQL Scripts.

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 SQL Assessment API provides a mechanism to evaluate the configuration of the SQL server for best practices. The API is delivered with a ruleset containing best practice rules suggested by the SQL Server team.

The SQL Server Assessment API Authoring package provides a public interface that helps extend the default mechanisms for evaluation of the SQL Server configuration for best practices using the SQL Server Assessment API.

Microsoft.Data.SqlClient Extensions Azure

Microsoft.SqlServer.Management.SqlParser provides T-SQL parsing functionality.

This package contains the SDK for building SQL Database Projects (.sqlproj) in .NET.

Always Encrypted Azure Key Vault Provider for Microsoft.Data.SqlClient. This library enables .NET applications to use Microsoft Azure Key Vault with Always Encrypted in Microsoft Azure SQL Database and Microsoft SQL Server. The library includes the column master key store provider that allows client applications to access data when a column master key is stored in Microsoft Azure Key Vault. For more information on Always Encrypted, please refer to: https://aka.ms/AlwaysEncrypted. Use this library only with the Microsoft.Data.SqlClient (https://www.nuget.org/packages/Microsoft.Data.SqlClient) client driver.

SqlPackage is a command-line utility that automates database development tasks by exposing some of the public Data-Tier Application Framework (DacFx) APIs.

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.

This library enables .NET Framework applications to use Microsoft Azure Key Vault with Always Encrypted in Microsoft Azure SQL Database and Microsoft SQL Server. The library includes the column master key store provider that allows client applications to access data when a column master key is stored in Microsoft Azure Key Vault. For more information on Always Encrypted, please refer to: https://aka.ms/AlwaysEncrypted. Use this library only with the legacy .NET Framework Data Provider for SQL Server within the System.Data.SqlClient namespace in .NET Framework. If you are using the Microsoft.Data.SqlClient (https://www.nuget.org/packages/Microsoft.Data.SqlClient) client driver, you need to use Microsoft.Data.SqlClient.AlwaysEncrypted.AzureKeyVaultProvider (https://www.nuget.org/packages/Microsoft.Data.SqlClient.AlwaysEncrypted.AzureKeyVaultProvider) instead of this package.

This NuGet package contains all the required components to build and publish sqlproj project. This package allows to users to create local build agent without installing visual studio and enables continuous integration and continuous deployment scenarios. SSDT transforms database development by introducing a ubiquitous, declarative model that spans all the phases of database development inside Visual Studio. You can use SSDT Transact-SQL design capabilities to build, debug, maintain, and refactor databases. You can work with a database project, or directly with a connected database instance on or off-premise. SSDT team's blog - https://blogs.msdn.microsoft.com/ssdt/ SQL Server Data Tools page - https://docs.microsoft.com/sql/ssdt/sql-server-data-tools

This package contains the master.dacpac for SQL Server 170.

This package contains the master.dacpac for Azure SQL Database.

XELite is cross platform library to read XEvents from XEL files or live SQL streams.

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.

Microsoft.Data.Tools.UnitTest.dll is a database unit test component in SQL Server Data Tools (SSDT). SSDT transforms database development by introducing a ubiquitous, declarative model that spans all the phases of database development inside Visual Studio. You can use SSDT Transact-SQL design capabilities to build, debug, maintain, and refactor databases. You can work with a database project, or directly with a connected database instance on or off-premise. You can use SQL Server unit tests to establish a baseline state for your database and then to verify any subsequent changes that you make to database objects. SSDT team's blog - https://blogs.msdn.microsoft.com/ssdt/ SQL Server Data Tools page - https://docs.microsoft.com/sql/ssdt/sql-server-data-tools More details about SQL Server unit Tests - https://docs.microsoft.com/sql/ssdt/verifying-database-code-by-using-sql-server-unit-tests

The Microsoft Data Encryption SDK provides encryption support to applications. It allows developers to implement column- or field-level encryption for data stored in various data stores, including Azure data services. Commonly Used Types: Microsoft.Data.Encryption.Cryptography.DataProtector Microsoft.Data.Encryption.Cryptography.DataEncryptionKey Microsoft.Data.Encryption.Cryptography.KeyEncryptionKey Microsoft.Data.Encryption.Cryptography.EncryptionSettings Microsoft.Data.Encryption.Cryptography.EncryptionKeyStoreProvider Microsoft.Data.Encryption.Cryptography.MicrosoftDataEncryptionException Microsoft.Data.Encryption.Cryptography.PlaintextDataEncryptionKey Microsoft.Data.Encryption.Cryptography.ProtectedDataEncryptionKey When using NuGet 3.x this package requires at least version 3.4.

This package contains the system database objects for SQL database in Microsoft Fabric. https://aka.ms/sqlproj-package-ref

This package contains the msdb.dacpac for SQL Server 170.

The SQL Server Management Objects (SMO) Framework is a set of objects designed for programmatic management of Microsoft SQL Server and Microsoft Azure SQL Database.

The SQL Server Management Objects (SMO) Framework is a set of objects designed for programmatic management of Microsoft SQL Server and Microsoft Azure SQL Database.

This package contains the master.dacpac for Microsoft Fabric DW.

Supports language service implementations by providing SQL Server metadata for completing TSQL statements.

The Microsoft Data Encryption SDK provides encryption support to applications. The Microsoft.Data.Encryption.AzureKeyVaultProvider enables .NET applications to use Microsoft Azure Key Vault to perform encryption/decryption. Commonly Used Types: Microsoft.Data.Encryption.AzureKeyVaultProvider.AzureKeyVaultKeyStoreProvider When using NuGet 3.x this package requires at least version 3.4.

Templates for creating new Microsoft.Build.Sql projects.

This package contains the master.dacpac for SQL Azure Synapse Analytics.

Microsoft.SqlServer.Management.SqlParser provides TSQL parsing functionality. This package provides localized resources for that DLL.

.NET client SQL Tools Service application, usable as a dotnet tool. This package is intended to be used by internal applications only and should not be referenced directly.

The SQL Server Management Objects (SMO) Framework is a set of objects designed for programmatic management of Microsoft SQL Server and Microsoft Azure SQL Database.

String Resource Tool creates C# wrapper classes for managed string resources. The app developer creates a .strings file to declare the list of strings. Each line includes the name of the string and its list of parameters. For example: ConnectionFailure(server) = Failed to connect to server {0}. The above line creates the following entry in the wrapper class: [System.Runtime.CompilerServices.CompilerGeneratedAttribute()] internal class StringConnectionInfo { public static string ConnectionFailure(string server) { return Keys.GetString(Keys.ConnectionFailure, server); } } The package includes a targets file for incorporating srgen into an msbuild-based development project and a sample strings file.

This package contains the master.dacpac for SQL Azure Synapse Serverless.

The Microsoft DacFx SQL Projects Library provides an interface for programmatically creating and editing .sqlproj files and their contents. It can be used to add, update, exclude, and delete items contained in a SQL Project, such as SQL object scripts, pre- and post-deployment scripts, publish profiles, SQLCMD variables, and database references, as well as to edit the property metadata of the project itself.

Microsoft.Data.SqlClient Extensions Logging - ETW EventSource for SqlClient tracing and diagnostics.

Open implementation of the TDS protocol (version 7.4) in managed C# code.

Implements SQL Management Object-based wrappers for the Microsoft.SqlServer.Assessment APIs

This library contains enclave providers for .NET Framework applications using Always Encrypted with secure enclaves. An enclave provider implements the client-side logic for the attestation protocol and for establishing a secure channel with a secure enclave inside SQL Server. For details on Always Encrypted with secure enclaves, see https://aka.ms/AlwaysEncryptedwithSecureEnclaves.

The SQL Server Management Objects (SMO) Framework is a set of objects designed for programmatic management of Microsoft SQL Server and Microsoft Azure SQL Database.

Microsoft.SqlServer.Management.SqlParser provides T-SQL parsing functionality.

SQL Tools Service application for the win-x64 runtime. This package is intended to be used by internal applications only and should not be referenced directly.

SQL Tools Service application for the osx-x64 runtime. This package is intended to be used by internal applications only and should not be referenced directly.

Root package for .NET client SQL Tools Service application. This package is intended to be used by internal applications only and should not be referenced directly.

.NET client Kusto Service application, usable as a dotnet tool. This package is intended to be used by internal applications only and should not be referenced directly.