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

 

Updated: November 17, 2016

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 very latest features of SQL Server. Older versions include the templates and design environment that were current for that release.

SSDT is backwards compatible, which means you can always use the newest SSDT to design and deploy databases, models, reports, and packages that run on older versions of SQL Server. You can also use any of the previously released versions listed below.

System_CAPS_ICON_note.jpg 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 will be installed per version of Visual Studio; installing a second SSDT just adds the missing templates.

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

ReleaseVisual Studio 2015Visual Studio 2013
16.5SSDT for VS2015 16.5SSDT for VS2013 16.5
16.4.1SSDT for VS2015 16.4.1SSDT for VS2013 16.4.1
16.3SSDT for VS2015 16.3SSDT for VS2013 16.3

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) -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 is between the two is the Visual Studio version.

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

Show: