Home
Microsoft

 

SQL Server Data Tools (SSDT) has historically been an all-in-one product that allows traditional SQL and BI users to develop SQL related projects including database projects, integration services projects, analysis services projects, reporting services projects, etc. It has been delivered as a standalone installer that allows you to install both the SSDT relational database components that ship with Visual Studio as well as additional components that ship separately from Visual Studio (Analysis Services, Reporting Services, Integration Services) into either an existing Visual Studio instance or a new Visual Studio shell instance if you don’t have one already.

 

With technologies being advanced and software releases being modernized, the delivery model of SSDT has been changing.

 

In Visual Studio 2017, we have made a few changes to SSDT delivery model.

  • The database components of SSDT have become a built-in workload in Visual Studio 2017, which do not require the standalone installer.
  • While Analysis Services and Reporting Services components can still be installed via the standalone installer, they can also be from the Visual Studio Market Place directly. (Integration Services component still requires the standalone installer.)

With Visual Studio 2019, we are announcing a few more changes to the delivery model of SSDT:

  • Following Analysis Services and Reporting Services, Integration Services component has also been made available in Visual Studio Market Place as an independent extension. Users can download and install it to an existing instance of Visual Studio 2019.
  • We will no longer offer the standalone installer of SSDT for Visual Studio 2019, since all of its components will become installable either from built-in workloads of Visual Studio or from the Market Place.

 

Some FAQs:

How do I get the Database Project and related features?

Same as Visual Studio 2017, select SQL Server Data Tools under the Data storage and processing workload during Visual Studio installation.

 

How do I get the Analysis Services, Reporting Services, or Integration Services projects?

You will be able to find and install them from Visual Studio Market Place as independent extensions.

 

I used to install Visual Studio through the SSDT standalone installer. How do I install Visual Studio now?

You can download and install Visual Studio 2019 directly from visualstudio.com.

 

But I don’t have license for professional or enterprise edition of Visual Studio.

The Community Edition of Visual Studio 2019 allows you to use the above components without the restriction on number of users. For details around licensing, please refer to the EULA of Community Edition.

 

12 Comments
Visitor

I like the direction this is headed, but did you really have to remove the Sql Server 2012 Target Server option from the latest versions of SSDT?  As developers we finally got Visual Studio to a point that we could support the newer servers and the older servers,  and now we have to take a step back to having 2 different installs if we want to update to anything past SSDT 15.8.0.

Microsoft

@jbleach , support for SQL Server 2012 was added back in SSDT version 15.9.0. Please refer to https://docs.microsoft.com/en-us/sql/ssdt/release-notes-ssdt?view=sql-server-2017#1590-ssdt-for-vs-2.... It is also available in the SSIS extension for VS 2019. 

Visitor

What do enterprise sized organisations who aren't allowed to use the community edition under the EULA and don't have professional or enterprise licences use to install SSDT 2019?

Microsoft

@BarneyL, the EULA of VS 2019 community edition has a section that specifically allows usage without user number restriction as long as you only use the SSDT components (including SSIS). Refer to https://aka.ms/AA4j4dx.

Occasional Visitor

Will SSIS/SSRS/SSAS ever get added to the VS 2019 installer as workloads/individual components to assist with developer visibility? With the new way of having them as extensions that need to be searched for and installed makes for extra work to configure a VS instance.

 

Also, not sure if this is intended or not, but when clicking the "Download" button on the new SSIS (Preview) entry on the Manage Extensions window it opened my web browser then used that to download the installer. This seems a little counter-intuitive if you're moving to deploying via the Extensions window. Will the final release just download the VSIX and install it like SSRS does?

 

Microsoft

@Runciter , we don't have a plan to add these extensions into built-in VS workloads. Shipping outside of the VS releases allows us to iterate faster and more flexibly. For the SSIS extension installation, it is expected that it is still done via an installer instead of VSIX. There are something in SSIS that need to be installed to machine-level, which cannot be included in a VSIX package. 

Occasional Visitor

@Tim.ChenThat does seem to be a bit of a step backwards as far as set up goes. Instead of going to the SSDT download page and downloading the installer and installing it while VS is closed, we now have to open VS, skip past the new start screen, open Extensions, find SSIS, click download which opens a browser to download the installer, then close VS and run the installer.

 

Is there no way it can be included as an initial workload and then updated via Extensions, like Live Share is?

Microsoft

@Runciter you can download the extension from a browser directly without going through VS. https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects&ssr=fa...

Occasional Visitor

@Tim.Chen We currently automate our builds of developer machines and azure devops build agents to ensure we have same versions of tooling used during development and build of code. VS2019 is installed using a pre-defined list of workloads complete with workload exclusions. Is there a method of automating installation of these VSIX files after VS2019 is installed and does it handle updates or do you have to uninstall/reinstall as stated in Rick Strahl's VSIX installer blog? We are able to automate installation of extensions in Visual Studio Code simply by providing a list of extension ids and it pulls and installs them on its own. I've filed a similar request here: https://github.com/MicrosoftDocs/visualstudio-docs/issues/3155

Microsoft

@scienter You'd better post this question to VS developer community, but personally I don't think VSIX installer can handle auto update. On the other hand, our SSIS designer installer is an EXE installer. It also supports quiet mode installation. You can launch it with "/?" argument to get detailed command line options.

Occasional Visitor

I cannot download the SQL integration vsix for Visual Studio 2019.  The download button does nothing.  This was working before.

Microsoft

@craig8769 , i just tried downloading from both the website and from VS, and it works fine. Can you try that again at a later time? It could be a transient issue.