Download SQL Server extended features and tools

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics

This article provides a brief explanation of the various downloads and stand-alone packages Microsoft provides to add value for SQL Server.

Analysis Services

Feature Description
Analysis Services Client Libraries The Microsoft Analysis Services client libraries encapsulate application programming interfaces (APIs) to authenticate and exchange requests and responses with Microsoft SQL Server Analysis Services 2005 or higher, Microsoft Azure Analysis Services, and Microsoft Power BI.

Microsoft Analysis Services client libraries include the following setup packages:
Microsoft Analysis Services ADOMD.NET
Microsoft Analysis Services OLE DB Provider (MSOLAP)
Microsoft Analysis Management Objects (AMO)
NuGetAnalysisSrvs NuGets for Analysis Services

Azure

Feature Description
SQL Server Backup to Windows Azure Tool Microsoft SQL Server Backup to Windows Azure Tool enables backup to Windows Azure Blob Storage and encrypts and compresses SQL Server backups stored locally or in the cloud.

Command-line, programming, and T-SQL

Feature Description
Command Line Utilities for SQL Server The SQLCMD utility allows users to connect to, send Transact-SQL batches from, and output rowset information from SQL Server instances.
Drivers for PHP for SQL Server The Microsoft Drivers for PHP for SQL Server are PHP extensions that allow for the reading and writing of SQL Server data from within PHP scripts.
JDBC Driver for SQL Server The Microsoft JDBC Driver for SQL Server provides access to SQL Server from any Java application, application server, or Java-enabled applet.
SQL Server Data-Tier Application Framework The SQL Server Data-tier Application framework (DacFx) is a .NET component that provides application lifecycle services for database development and management and is available in the SqlPackage CLI and as a NuGet package. The Data-tier Application Framework includes TransactSql.ScriptDOM.
SQL Server Semantic Language Statistics The Semantic Language Statistics Database is a required component for the Statistical Semantic Search feature in Microsoft SQL Server.
SQL Server Management Objects SQL Server Management Objects (SMO) is a .NET Framework object model that enables software developers to create client-side applications to manage and administer SQL Server objects and services.
System CLR Types The SQL Server System CLR Types package contains the components implementing the geometry, geography, and hierarchy ID types in SQL Server. Note: This component also requires Windows Installer 4.5.
Windows PowerShell Extensions for Microsoft SQL Server The Microsoft Windows PowerShell Extensions for SQL Server include a provider and a set of cmdlets that enable administrators and developers to build PowerShell scripts for managing instances of SQL Server.

Database engine

Feature Description
Command Line Utilities for SQL Server The SQLCMD utility allows users to connect to, send Transact-SQL batches from, and output rowset information from SQL Server instances.
Remote Blob Store The SQL Server Remote Blob Store is a method for storing blobs of unstructured data in an external Content Addressable data store. The component consists of a client-side DLL that is linked into a user application, and a set of stored procedures to be installed on SQL Server.
SQL Server Upgrade Advisor Microsoft Upgrade Advisor analyzes instances of SQL Server in preparation for upgrading to SQL Server.

Integration Services

Feature Description
Integration Services Feature Pack for Azure The Microsoft Integration Services Feature Pack for Azure provides tools for using IS to connect to the Azure Stack.

Kerberos

Feature Description
Kerberos Configuration Manager for Microsoft SQL Server Kerberos authentication provides a highly secure method to authenticate client and server entities (security principals) on a network.

Master Data Services

Feature Description
Master Data Service Add-in for Microsoft Excel The Master Data Services (MDS) Add-in for Microsoft Excel is a data management tool that delivers a multitude of master data management capabilities with ease and efficiency.

Providers and Drivers

Feature Description
ODBC Drivers for Microsoft SQL Server The Microsoft ODBC Drivers for SQL Server provide native connectivity from Windows and Unix to Microsoft SQL Server and Microsoft Azure SQL Database.
OLEDB Provider for DB2 for Microsoft SQL Server The Microsoft OLE DB Provider for DB2 v5.0 offers a set of technologies and tools for integrating vital data stored in IBM Db2 databases with new solutions. SQL Server developers and administrators can use the data provider with integration Services, Analysis Services, Replication, Reporting Services, and Distributed Query Processor. Read the Installing Data Provider section of the product documentation, which is available on-line or as a download.

Reporting Services

Feature Description
Report Builder Report Builder provides a productive report-authoring environment for IT professionals and power users. It supports the full operational reporting capabilities of SQL Server Reporting Services.
Reporting Services Add-in for Microsoft SharePoint Reporting Services Add-in for Microsoft SharePoint technologies allows you to integrate Reporting Services features with the collaborative SharePoint experience.
Report Viewer control for ASP.NET Web Forms apps This Report Viewer control enables you to embed SQL Server Reporting Services paginated reports into your ASP.NET Web Forms apps.
Report Viewer control for Windows Forms apps This Report Viewer control enables you to embed SQL Server Reporting Services paginated reports into your Windows Forms apps.

SQL Server Data Tools

Feature Description
SQL Server Data Tools (SSDT) SQL Server Data Tools is a modern development tool for building SQL Server relational databases, Azure SQL databases, Analysis Services (AS) data models, Integration Services (IS) packages, and Reporting Services (RS) reports. With SSDT, you can design and deploy any SQL Server content type with the same ease as you would develop an application in Visual Studio.

See also

Contribute to SQL documentation

Did you know that you can edit SQL content yourself? If you do so, not only do you help improve our documentation, but you also get credited as a contributor to the page.

For more information, see How to contribute to SQL Server documentation