Visual Studio 2019 brings new installation of SQL Server Integration services and SQL Server Analysis Services and SQL Server Reporting Services.
There is no need to download SSDT (SQL Server Data Tools for Visual Studio) as used to do with Visual Studio 2017 or previous versions.
During the installation process of Visual Studio 2019, make sure to select SQL Server Data Tools under Data Storage and processing.
Once installation process is finished, you will need to download Visual Studio extensions, since all three services have been moved out of standalone SSDT and merged (introduced) with extensions.
Run Visual Studio 2019 and run Extensions -> Manage Extensions.
Simply search for all three services and install them.
Integration Services are named as: SQL Server Integration Services Projects extension:
Analysis Services are named as: Microsoft Analysis Services Projects extension:
And Reporting Services are named as: Microsoft Reporting Services Projects extension:
All three extensions are created by Microsoft, which, besides the description, is a the right tool that previously came with SSDT.
After you have downloaded the extensions, Visual Studio will schedule the changes and the modifications will begin when Visual Studio will be closed (re-opened) and VSIX Installer will kick-in and do the installation – but only for Analysis Services and Reporting Services.
Integration Services extension (the one in preview), will be downloaded as an executable file (*.exe) and will be installed separately, similar to installing SSMS or SSDT for older versions of Visual Studio.
After all the installation is over, you can start using Visual Studio 2019 for SSRS, SSIS or SSAS projects.
Happy SQLing 🙂