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.
Answer from maXer on Stack Overflowsql server data tools - SSDT for Visual Studio 2019? - Stack Overflow
Issue With SSDT (Visual studio 2019)
Visual Studio 2019 Community Edition for SQL Server Development
SQL Server Developer Edition - SSDT/SSIS? – SQLServerCentral Forums
Videos
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.
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.
Hi All,
Since SSDT has been integrated with Visual Studio as a plugin/add-on. Can VS2019 Community Edition be used for SQL Server Development?
https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver15
The first page of the license agreement for VS2019 Community edition seems to have many references to SQL Server Development even for users under an organization or enterprise.
section 1b point 4 and point 6
https://visualstudio.microsoft.com/license-terms/mlt031819/
If you want to use Visual Studio together with the Data Tools, then you can use the free VS Commuinty Edition, see
https://learn.microsoft.com/en-us/answers/questions/826062/about-license-for-using-sql-server-data-tools-(ssd
Hi @michael Lang,
SSDT is no more for SSIS.
SSIS has two environments:
- Development environment on the developer workstation with two software products installed (1) VS2019 or VS2022, (2) "SQL Server Integration Services Projects" extension for VS. This particular piece replaced the SSDT.
- Production environment on the SSIS run-time server with the following installed: SQL Server database instance with SSIS component.
Trying to get my head around the licensing requirements for using SSDT for VS2019...
Up until the VS2019 version, you could plainly understand it could be installed 'free' via using the standalone installation & it would include Visual Studio Shell edition of the relevant version.
With 2019, it now says if you are licensed for Visual Studio Pro/Ent to install that & then add the SSIS/SSRS/SSAS Extensions.... Or if you don't have VS licensed, you can install VS Community edition & do the same.
But.... VS Community edition licensing says if you have 250+ PCs you cannot use it (except for learning & open source work).
Kinda sucks if something that's always been 'free' is now requiring licensing...