Installing SSDT (SQL Server Data Tools) 2019

The Business Intelligence platform has been changing on each new version.

In the beginning, it was part of the SQL Server setup, and then since SQL Server 2014 started to be distributed separately.

Also, the name of this tool and its installation method started to vary from version to version of Visual Studio (VS).

For installing the SQL Server Data Tools 2017, you need only download and execute. However, everything has changed in the 2019 version.

This post aims to show all the processes of installing and configuring the SQL Server 2019 Business Intelligence development environment.

Download and install the Visual Studio 2019

The first step is to download the Visual Studio 2019 Community:

During the installation process of Visual Studio 2019, select “SQL Server Data Tools” under Data Storage and processing, as shown below:

When the installation is complete, you will need to download VS extensions since all three services ( SSIS, SSRS, and SSAS) have been moved out of standalone SSDT and merged (introduced) with extensions.

Add new extensions to VS

Open the  Visual Studio and click on “Continue without code”, go to Extensions -> Manage Extensions;

In the search bar of the opened window, type “SSDT” to easily locate all the SSDT extensions. From the appeared list, choose one and press “Download”.

After download the extension, close the visual studio and execute the downloaded .exe file.

Fallow the simple steps, repeat the process for all the services that you need install (SSIS, SSRS, and SSAS).

When the setup is completed, you can open the VS again.

Creating a new project

In Visual Studio, choose “Create a new project” and search for the type (e.g. Integration Services Project) and click on it, as show below:

It`s ready! Your development environment is complete.

Now you can create reports on Reporting Services, load data using Integration Services, and develop and deploy models with Visual Studio with Analysis Services projects.

From database design to troubleshooting SQL server problems, our SQL server experts are on hand to assist. 

Mark Varnas

Mark Varnas

I love making performance tuning SQL Servers fast and making them more stable. And I channel that obsession into our SQL Managed Services and new content here. When I'm not writing about SQL, I spend time outside hiking, skiing, mountain biking, or trying a new recipe.

4 Responses

Leave a Reply

Your email address will not be published. Required fields are marked *