Visual Studio 2022 support for SS Data Tools
ssis - Unable to open / upgrade SSDT 2015 package in Visual Studio SSDT 2022 - Stack Overflow
How Do I Add SSDT to MS SQL Server that's already installed and in use
Which Visual Studio 2022 edition should I select for using SQL Server Data Tools? - Stack Overflow
Videos
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.
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.
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?