Hi @Greg Booth ,
Welcome to Microsoft Q&A!
Visual Studio 2022 Community provide core SQL Server Data Tools functionality. But in your situation, I recommend you use the Professional or Enterprise editions.
For SSDT, it has been integrated into Visual Studio 2022.
You can install it as individual component in Visual Studio Installer > Modify.
For Integration Services (SSIS) and Reporting Services (SSRS) projects, you need to install the appropriate extensions from within Visual Studio with Extensions > Manage Extensions or from the Marketplace.
· Integration Services
· Reporting Services
For more information, please visit: Download SSDT for Visual Studio.
Sincerely,
Anna
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Videos
Background: So I have the need to generate an array of JSON objects in a single column in my main select. I found that you can do this with a new feature in SQL 2022. There's a new function called JSON_OBJECT which works perfectly if you combine it with FOR JSON PATH in a subquery.
The problem is all my table structures, procs, schemas and views are in a VISUAL STUDIO database project which, when compiled, generates a nice little DACPAC file which I can then use to deploy to the database on the production server.
The production server also runs SQL Express so upgrading it is not an issue.
I installed SQL 2022 express and tried to write my new little view to generate the data in the format I need which works perfectly, but I cannot change the "Target platform" in my database project to SQL 2022, the option is simply not there. I have googled and the Microsoft docs says you cannot install SSDT seperately as of Visual studio 2019. ( I am using VS2022). It comes with visual studio when you select the SSDT feature
So now as soon as I create the view and add it to the database project I get baraged with syntax errors because the project doesnt understand the format of my new view that uses my new JSON_OBJECT function.
How can I resolve this? Is there a forum I can post this to so that the SQL engineers at Microsoft can fix this?
Thanks to all of the answers, but I think I found what I was looking for in the Visual Studio Community Edition license: https://visualstudio.microsoft.com/license-terms/mlt031819/
My understanding, is that this allows me to use Visual Studio 2019 Community Edition for SSDT tools in an enterprise setting.
You don't have to install SSDT in Visual Studio 2019, even in Community. Go to new project and type SQL and hit return. It will say something like "SQL Server Database Project". Guess what? That's SSDT. In older versions, it was a separate install. It is now part of the core Visual Studio. And you upgrade it, if there are any, the same way you do anything else.
Already installed Visual Studio? No problem. Reopen the installer and install the data tools. This can be part of the payloads they have (I forget which one, but it has to do with data) or you can click on the tab that allows you to install individual components and search for the SQL tools. Once installed, they are there.
I don't belie you can install using the SSDT separate installer anymore, just like you know handle all of the .NET Core installs in Visual Studio, rather than separate. Kathleen Dollard outlined this in one of her posts last year (not SSDT, but .NET Core, etc.), so it has been a bit more than a year these things got folded into the installer. Core may still allow download and install? Not sure. But SSDT is the SQL project in 2019.
I did a fresh install of windows on my main computer and went ahead and installed SQL Server 2019 Developer Edition.
I do a lot of work with SSIS and SSAS (Tabular) and assumed the Visual Studio Extension used for these modules would be available in Visual Studio 2022 Community so I went ahead in installed that too. To my suprise when I loaded it up, it did not support working on these projects only "Database Projects" not involving SSIS or SSAS. So I had to uninstall 2022 and roll back to 2019.
Any idea when VS 2022 will be supporting SQL Server Data Tools? Supposedly 2022 is much better than 2019 as its the first 64 bit version of VS.
Update 5 Jun. 2023 - General Availability (GA) release
Microsoft released Version 1.0 (General Availability (GA) release) of the SQL Server Integration Services extension for Visual Studio 2022.
Update 24 Nov. 2022 - Public preview released
Microsoft added a public preview of the SQL Server Integration Services Projects 2022 to the Visual Studio marketplace, which is tested against Visual Studio 2022 17.4
Read the announcement
Update 19 Sep. 2022
Microsoft Data Platform MVP Andy Leonard stated that "I communicated with the Microsoft SSIS Team. They shared they are targeting a preview of VS2022 Integration Services Extension for the end of CY22".
Update 12 Jul. 2022
Microsoft announced the support for Visual Studio 2022 via the Microsoft Analysis Services Projects 2022 extension.
Update 01 Jul. 2022
Microsoft mentioned that Visual Studio 2022 support is one of the major items they are working on, and it will be released before the end of the year.
Update 23 Jun. 2022
Microsoft released SSIS 4.0, adding support to SQL Server 2022, but still, this version does not support Visual Studio 2022.
In addition, the support of Visual Studio 2022 is added as a common issue
Update 23 Feb. 2022
Microsoft released SSIS 3.16, where the support of Visual Studio 2022 is removed from the SSIS Installer (Bug fixed).
Initial Answer - 16 Feb. 2022
Microsoft SQL Server business intelligence extensions are still unavailable for Visual Studio 2022.
Many people are still confused about the difference between SQL Server Data Tools used to create SQL databases projects and the business intelligence suite:
- SSDT, SSDT-BI confusion in backwards compatibility for different SQL version
Using Visual Studio 2022, only the SQL Server Data Tools required to create database projects are currently available. As mentioned in the official documentation:
The core SSDT functionality to create database projects has remained integral to Visual Studio. The extensions for Analysis Services, Integration Services, and Reporting Services projects are currently unavailable for Visual Studio 2022.
You can note that in the Visual Studio marketplace, only Visual Studio 2019 is mentioned:
As Microsoft support commented on 2022-02-08:
Supporting VS2022 is on our radar, but there's no exact ETA now.