nugetsqltools
NuGet publisher profile
Packages (68)
Microsoft.Data.SqlClient
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.
Microsoft.Data.SqlClient.SNI.runtime
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.SqlServer.Server
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
Microsoft.Data.SqlClient.SNI
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.SqlServer.SqlManagementObjects
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.TransactSql.ScriptDom
The Microsoft SQL ScriptDOM library provides parsing and analysis capabilities for management and development of TSQL Scripts.
Microsoft.SqlServer.Assessment
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.
Microsoft.SqlServer.DacFx
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.
Microsoft.SqlServer.Assessment.Authoring
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.Abstractions
Microsoft.Data.SqlClient Extensions Abstractions
Microsoft.Data.SqlClient.Internal.Logging
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.SqlServer.Management.SqlParser
Microsoft.SqlServer.Management.SqlParser provides T-SQL parsing functionality.
Microsoft.Data.SqlClient.AlwaysEncrypted.AzureKeyVaultProvider
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.
Microsoft.Build.Sql
This package contains the SDK for building SQL Database Projects (.sqlproj) in .NET.
Microsoft.SqlPackage
SqlPackage is a command-line utility that automates database development tasks by exposing some of the public Data-Tier Application Framework (DacFx) APIs.
Microsoft.SqlServer.DacFx.x64
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.SqlClient.Extensions.Azure
Microsoft.Data.SqlClient Extensions Azure
Microsoft.SqlServer.Management.AlwaysEncrypted.AzureKeyVaultProvider
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.
Microsoft.Data.Tools.Msbuild
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
Microsoft.SqlServer.XEvent.XELite
XELite is cross platform library to read XEvents from XEL files or live SQL streams.
Microsoft.SqlServer.DacFx.x86
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.SqlServer.Dacpacs.Azure.Master
This package contains the master.dacpac for Azure SQL Database.
Microsoft.SqlServer.Dacpacs.Master
This package contains the master.dacpac for SQL Server 170.
Microsoft.Data.Tools.UnitTest
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
Microsoft.Data.Encryption.Cryptography
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.
Microsoft.SqlServer.ConnectionInfo
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.SqlManagementObjects.SSMS
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.Dacpacs.Msdb
This package contains the msdb.dacpac for SQL Server 170.
Microsoft.SqlServer.Management.SmoMetadataProvider
Supports language service implementations by providing SQL Server metadata for completing TSQL statements.
Microsoft.SqlServer.Dacpacs.DbFabric
This package contains the system database objects for SQL database in Microsoft Fabric. https://aka.ms/sqlproj-package-ref
38 more packages load after hydration.