VS 2022 not opening Sql Database sqlproj

Question

I was recently issued a new laptop. The prior laptop VS 2017 upgrade--> 2019 upgrade-->2022.
We have multiple SQL Database Project used to manage our ... database projects.
On the new laptop I installed VS 2022 and checked to include the SQL Server Data Tools project. I did the same for the VS Build Tools 2019.

Now the Database projects no longer load.
In all of the .sqlproj files there is this section

I think the issue may reside here, but I'm not sure.
Has anyone encountered and resolved this?

Answer 1

Hello @Paul Hunter ,

Thank you for sharing the screenshot.

I agree with you. The issue should be related to the properties in project files.

I see $(VisualStudioVersion) and 11.0, as you are using Visual Studio 2022, the number/version should be 17.0(details: Fields).  

The path is incorrect. I suggest you check your project files(.sqlproj) and try to manually change 11.0 to 17.0. See if this works.

Best Regards,

Tianyu

---

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.

Answer 2

@Tianyu Sun-MSFT
I changed from 11 to 17 and tired reloading the project. That didn't work and generated the ActivityLog.Setup.xml file which I've attached as ActivityLog.Setup_v17.zip.xml (remove .xml ... it's a zip)

One link I'd ignored was about Pre-MSBuild projects. It looks to fit my situation - a clean build of VS 2022 version 17.13 - and I need v 17.12 in order to convert them.