Download SQL Server Data Tools (SSDT)

 

Updated: November 17, 2016

SQL Server Data Tools is a modern development tool that you can download for free to build SQL Server relational databases, Azure SQL databases, Integration Services packages, Analysis Services data models, and Reporting Services 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. This release supports SQL Server 2016 through SQL Server 2005, and provides the design environment for adding features that are new in SQL Server 2016.

download Download SQL Server Data Tools for Visual Studio 2015Download Data-Tier Application Framework (DacFx)
Download SQL Server Data Tools (16.5)Download DacFx and SqlPackage.exe (16.5)Current GA release for production use.
Download SQL Server Data Tools (17.0 RC1)Download DacFx and SqlPackage.exe (17.0 RC1)Includes support for SQL Server vNext CTP1, but not recommended for production use.

If you don't have Visual Studio installed on your machine, installing SSDT will also install a minimal “Integrated Shell” version of Visual Studio 2015. This version of Visual Studio is free to install and use on as many machines as you wish. It gives you all the SQL Server project types, plus SQL Server Object Explorer and other SQL tools experiences.

If you do have Visual Studio 2015 Community Edition (or above) installed on your machine, installing SSDT will add the full set of SQL Server tools into your existing Visual Studio installation. Visual Studio includes many features you might want to use, such as Source Code Control integration and non-SQL language support. We recommend using Visual Studio 2015 Community or above to get the best experience when developing T-SQL.

Project TemplatesSQL Platforms Supported
Relational databasesSQL Server 2005* - SQL Server 2016

Azure SQL Database

Azure SQL Data Warehouse (supports queries only; database projects are not yet supported)

* SQL Server 2005 support is deprecated,

please move to an officially supported SQL version
Analysis Services models

Reporting Services reports
SQL Server 2008 – SQL Server 2016
Integration Services packagesSQL Server 2012 – SQL Server 2016

After installing SSDT, work through these tutorials to learn how to create databases, packages, data models, and reports using SSDT:

SQL Server Data Tools in Visual Studio
SSDT MSDN Forum
SSDT Team Blog
SSDT Connect Feedback
SSDT Documentation
DACFx API Reference
Download SQL Server Management Studio (SSMS)

Show: