For the purposes of this article, we will focus on SSDT for Visual Studio 2015. The page is shown in the image below.Īs of the date this article was written, the current release number for SSDT is 17.2 with a corresponding build number of 7.300. The starting point for installing SSDT is this Microsoft Docs site. Finally, we’ll review how to uninstall SSDT.

We’ll also review adding or removing tools from an existing SSDT installation followed by a brief look at some of the other components installed to support SSDT. This article will detail the steps for obtaining the SSDT installer, demonstrate the installation process using both an online and offline method through the install wizard and command-line as well as launching SSDT for the first time. The SSDT installer must be downloaded from Microsoft. SSDT is a standalone application in that since SQL Server 2012, is not included in the SQL Server installation media as was the case with BIDS in SQL Server 2005 through SQL Server 2008 R2. Additionally, SSDT can be used to create SQL Server Database Projects where DDL for the various objects related to a solution can be created, managed, compared along with the ability to create point-in-time project-level snapshots. SSDT can be used to create Analysis Services, Integration Services and Reporting Services projects just as its predecessor BIDS. SQL Server Data Tools, commonly referred to as SSDT, replaced Business Intelligence Development Studio (BIDS) with the release of SQL Server 2012.

Microsoft sql server 2016 download iit