You can download SSDT directly from Download SQL Server Data Tools (SSDT) or you can also download it using the Install SQL Server Data Tools link on the SQL Server 2016 Installation Center. Getting the new SSDT is now more straightforward than in earlier releases as well. SSDT 2016 can run on the following operating systems: Integration Services –SQL Server 2012 through SQL Server 2016.Reporting Services - SQL Server 2008 through SQL Server 2016.Analysis Services - SQL Server 2008 through SQL Server 2016.Relational databases - SQL Server 2005 though SQL Server 2016, Azure SQL Database, Azure SQL Data Warehouse (SQL Server 2005 is officially at the end of support).SSDT 2016 supports development for a number of different SQL Server releases including: Supported SQL Server and Windows Versions With the SQL Server 2016 release the former Data Dude capabilities have been incorporated into the main Visual Studio family and the BIDS feature set is now the new SQL Server Data Tools (SSDT). The Data Dude project became known as just SQL Server Data Tools (SSDT) and it was used for data and schema compare as well as versioning and other database development. The BIDS project became known as SQL Server Data Tools-BI (SSDT-BI) and it was used to develop Analysis Services projects, Integration Services packages and Reporting Services reports – all vital to SQL Server BI subsystems. In spite of sharing the same moniker, each of these tools had very different purposes. The other was the descendant of a project called Data Dude.

One of them was the descendant of the Business Intelligence Development Studio (BIDS) which was last officially part of the SQL Server 2008 and SQL Server 2008 R2 release.

In the past, SQL Server Data Tools was the name of two separate and quite different products. In a long overdue move Microsoft has drastically changed the installation process for SQL Server Data Tools with the SQL Server 2016 release.

Microsoft sql server 2016 download free