SSDT for Visual Studio 2019? [closed]

Asked 15/2, 2019 at 10:29 Answered 13/4, 2019 at 23:17

visual-studio sql-server-data-tools visual-studio-2019

I have found the installer for the VS2017 version here, but is there one for the 2019 preview version?

Habitant answered 15/2, 2019 at 10:29 Comment(1)

"techcommunity.microsoft.com/t5/SQL-Server-Integration-Services/…" --> "marketplace.visualstudio.com/…" --> This is a free preview version 3.0 of SSIS tools for Visual Studio 2019 – Shaunda 27/4, 2019 at 13:10

SQL Server Reporting Services and SQL Server Analysis Services (SSRS, SSDT, SSAS, MSAS): Support for these project types is provided through two extensions in the Visual Studio Gallery: Microsoft Analysis Services Modeling Projects and Microsoft Reporting Services Projects. SSDT support is also included with the Data Storage and Processing workload in Visual Studio 2019.

SQL Server Integration Services (SSIS): Support for Visual Studio 2019 is coming soon. Get latest news from the SQL Server Data Tools Team Blog.

*the info source is here.

Noshow answered 4/4, 2019 at 19:51 Comment(4)

April 19, 2017 => Latest news? – Ligula 5/4, 2019 at 8:14

There is also important to switch to english language pack, because VS searches components in relevant language. – Medin 4/1, 2020 at 21:59

The SQL project might show as incompatible even after installing this extension. Right click the project and reload. My setup: rptproj with extension version 2.6.3. I did a reboot after the installation; not sure whether that did anything. – Sussman 6/1, 2020 at 19:35

For SSRS report project (rptproj) installing Microsoft Reporting Services Projects worked for VS2019 – Sonnnie 11/2, 2020 at 19:53

April 15th, 2019 Release of SQL Server Integration Services Projects (Version 3.0 Preview):

https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects&ssr=false#overview

Update: opened an existing dtproj successfully in Visual Studio 2019, and so far, Script Components have kept their code in-between saves

Note: For users who are worried about downloading Visual Studio Community Edition for commercial use.

The EULA of VS 2019 community edition has a specific section that allows enterprise users to use it for the SSDT workload. See https://visualstudio.microsoft.com/license-terms/mlt031819/.

Any number of your users may use the software only for Microsoft SQL Server development when using the SQL Server Data Tools or the extensions “Microsoft Analysis Services Projects”, “Microsoft Reporting Services Projects”, or “SQL Server Integration Services Projects” to develop Microsoft SQL Server database projects or Analysis Services, Reporting Services, Power BI Report Server, or Integration Services projects.

Epoxy answered 13/4, 2019 at 23:17 Comment(3)

You can also now find the SSIS extension inside Visual Studio by entering: "SQL Server Integration Services Projects" into the extensions dialog search box. – Ramonramona 1/5, 2019 at 0:38

Thank you, this is the missing piece! (along w/ the aforementioned extensions listed in the official docs.) Note that while you you can find it in the extensions search, it's still an external .exe download, and must have VS closed to install. – Parthenope 25/9, 2019 at 21:30

Recommend not using. It's full of bugs (Feb 2020). It does stuff like randomly deletes all your connections, is painfully slow and wrecks deployments. I would suggest MS haven't even tested it and they are relying on the community to update them, but updates are few and far between. Stick with 2017 probably for a couple of years. – Frumenty 18/2, 2020 at 20:37

In the Visual Studio 2019 installer make sure you've selected the Data Storage and Processing payload. It will install the latest version of SSDT into your Visual Studio 2019 installation:

Afterward, it shows up here (for me):

Thane answered 15/2, 2019 at 13:5 Comment(4)

Huh I have done that, but the SSDT folder does not show up inside my VS2019 directory. – Habitant 15/2, 2019 at 14:42

If you install this way, this may install some bits but you are still unable to open any SSRS or SSIS packages as it says they are unsupported. According to the comment here from MSFT they will be releasing a preview release during April: developercommunity.visualstudio.com/content/problem/400935/… – Estellaestelle 3/4, 2019 at 14:2

Sadly, the documentation for the changes to how SSIS is handled in VS 2019 isn't really working. You must still download the 400mb extension and install it (reboot required). It's in preview currently, but i've confirmed i'm able to open my previous SSIS projects. marketplace.visualstudio.com/… – Sculpt 18/7, 2019 at 17:13

I had to open VS, go to Extensions --> Manage Extensions, then search for Microsoft Reporting Projects or something, close VS, install that, then was good. – Fouquiertinville 29/12, 2020 at 23:23

it is showing on the same page for which you gave the link.. but it seems not yet released by ms itself..

best way is to raise a ticket with ms if you have support agreement ..

Bighead answered 15/2, 2019 at 10:34 Comment(4)

I think that website has a bug - it shows the same page for every selected version. – Habitant 15/2, 2019 at 10:35

if you select 2014 it shows a message that latest version is shown.. – Bighead 15/2, 2019 at 10:39

The requested page is not available for SQL Server 2014. You have been redirected to the newest product version this page is available for. – Bighead 15/2, 2019 at 10:39

Even after release date of VS2019 still no SSDT, and yes page is bugged, they will just show the one for SSDT 2017 anyway... – Matrass 3/4, 2019 at 10:35

Recommended topics

Hot tags