Previous releases of SQL Server Data Tools (SSDT and SSDT-BI)

THIS TOPIC APPLIES TO: yesSQL ServeryesAzure SQL DatabaseyesAzure SQL Data Warehouse yesParallel Data Warehouse

SQL Server Data Tools (SSDT) provides project templates and design surfaces for building SQL Server content types — relational databases, Analysis Services models, Reporting Services reports, and Integration Services packages.

It's based on a Visual Studio shell and co-released with SQL Server. New versions of SSDT integrate the latest features of SQL Server. Older versions include the templates and design environment that were current for that release.

SSDT is backwards compatible, so you can always use the newest SSDT to design and deploy databases, models, reports, and packages that run on older versions of SQL Server.

Note

Historically, the Visual Studio shell used to create SQL Server content types has been released under various names, including SQL Server Data Tools, SQL Server Data Tools - Business Intelligence, and Business Intelligence Development Studio. Previous versions came with distinct sets of project templates. To get all of the project templates together in one SSDT, you need the newest version. Otherwise, you will probably need to install multiple previous versions to get all of the templates used in SQL Server. Only one shell is installed per version of Visual Studio; installing a second SSDT just adds the missing templates.

Recent downloads

The last few downloads are provided for the unlikely event that you experience issues with the latest release.

Release Visual Studio 2015 Visual Studio 2013
17.3 SSDT for VS2015 17.3 * n/a
17.2 SSDT for VS2015 17.2 * n/a
17.1 SSDT for VS2015 17.1 * n/a
17.0 SSDT for VS2015 17.0 * n/a
16.5 SSDT for VS2015 16.5 SSDT for VS2013 16.5

* SSDT supports the two most recent versions of Visual Studio. With the release of Visual Studio 2017, SSDT for VS2013 is no longer being updated. For additional information, see the FAQ section of this SSDT team blog post.

SQL Relational: Database Engine

Provides templates for building relational databases for the RDBMS and Azure SQL Database. SSDT is version agnostic with respect to relational database design. You can use either the Visual Studio 2012 or 2013 version with any version of SQL Server Database Engine or Azure SQL Database.

Database Designers

Visual Studio 2013 customers can download a preview version of SSDT to try out new features that are not yet in the product release version.

SQL BI: Analysis Services, Reporting Services, Integration services

BI templates are used to create SSAS models, SSRS reports, and SSIS packages. BI Designers are tied to specific releases of SQL Server. To use the newer BI features, install a newer versioned BI designer.

BI Designers

Download SSDT-BI for Visual Studio 2013 (SQL Server 2014, SQL Server 2012, SQL Server 2008, and 2008 R2)

Download SSDT-BI for Visual Studio 2012 (SQL Server 2014, SQL Server 2012, SQL Server 2008, and 2008 R2

Business Intelligence Development Studio (BIDS) is installed via SQL Server Setup. There is no web download. (SQL Server 2008, and 2008 R2)

For SQL Server 2012 or 2014, you can use either SSDT-BI for Visual Studio 2012 or SSDT-BI for Visual Studio 2013. The only difference between the two is the Visual Studio version.

See Also

Download SQL Server Data Tools (SSDT)
Download SQL Server Management Studio (SSMS)
SQL Tools and Utilities