This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 78%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
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.
@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.
Hi @Paul Hunter ,
Are there any other path properties/items in your project file(.sqlproj)?
I think you can try to check the path mentioned in the project file, for example:
$(MSBuildExtensionsPath)\Microsoft\VisualStudio\v$(VisualStudioVersion)\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets.
The v$(VisualStudioVersion) here, I believe should be v17.0. Can you confirm that v17.0 folder does exist on your machine but v11.0 doesn’t exist on your machine?
On my side, I have VS 2019 and VS 2022 installed, so I also have v16.0(VS 2019) folder.
(C:\Program Files\Microsoft Visual Studio\2022\Community\MSBuild\Microsoft\VisualStudio\v17.0)
Please try to directly replace the path to absolute path for testing. Once the file can be found, the project may be loaded correctly.
Following paths are the paths that you can try to modify to absolute paths to check:
Actually, I suggest you try to create a new SQL Server Data Tools project from VS 2022 and check its project file. Match the properties, items, paths and version numbers, see if some configurations need to be changed.
That didn't work and generated the ActivityLog.Setup.xml file which I've attached as ActivityLog.Setup_v17.zip.xml
I'm sorry, but I didn't see the attached file(s), maybe you can attach it/them again.
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.
The link you shared seems redirect to this thread, could you kindly double confirm it?
Besides, per your description, have you tried v 17.12? The previous version (Enterprise, Professional, Build Tools) of VS 2022 can be downloaded and installed from here: Fixed version bootstrappers.
Feel free to contact us :)
Thanks for the question Tianyu Sun-MSFT.
I uninstalled VS 17.13, installed VS 17.12. I was then able to "reload with dependencies", and finished by updating back to VS 17.13. My assumption is that my old laptop had upgraded sequentially over time, so the issue never surfaced. My new laptop started off with the latest version.
Thanks for your assistance.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 32%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
The snippet of project file you posted is fine. Even on VS 2022 it still contains this code for older VS versions. You didn't really tell us what error you're getting, which would help identify the issue. The output window in VS should tell you what failed.
Most likely your project file contains old stuff in it that is causing an issue with the newer extension. There are 2 approaches you can take here I think.
The first option is to create a new database project in VS 2022. Then open the project files in a text editor and compare them. My gut instinct is that the base properties in the PropertyGroup for the configuration/platform has a value that is bad. For example it might still be referencing an older version of NET Framework which would likely cause the load to fail. Update your existing database project to ensure its properties line up. If there are extra properties then you could consider commenting them out for now. Then try to reload the project.
If that doesn't work, or you are fine leaving the old project behind, create a new database project in VS 2022. Then copy all the project items from the old project to the new one. To make this easier you can create the new database project and then move the project file to the same directory as the current project. Once you've moved everything then delete the old project file. Be sure to wipe out any bin, obj directories and any cache files that are generated. Then try reloading the project.