Installing SSDT
SQL Server data tools (SSDT) for those that don’t know is an IDE for building SQL server content (Relational DBs, SSIS, SSRS or SSAS projects and packages). It’s gone by a few different names over the years (and versions) but broadly speaking, no matter the name, they all have the same look and feel. What has changed though, is how you install it.
Prior to SQL server 2012, BIDS ( Business Intelligence Development Studio) was as an optional install within every SQL server installation to develop SSIS, SSAS, SSRS packages. It did not however support the development of relational databases. However, since SQL 2012 onward Microsoft, stopped shipping SQL server with BIDs and began to take steps to integrate it into Visual Studio and leverage a number of key benefits it already offered such as refactoring and integrated source control. How to install SSDT in the various versions of Visual studio is described below.
SSDT for VS 2010 to VS 2015
This first integration step took the form of a Visual Studio shell product which was installed as a separate ISO image.
Steps to install:
- Download SSDT for Visual Studio 2015
- Launch the ISO image.
- Run the SSDTSetup.exe executable:
SSDT for VS 2017
With Visual Studio 2017, SSDT came as an integrated installation option when choosing your workloads:
