This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(57.599999999999994, 15%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
Hi, I am trying to upgrade my Visual Studio 2017 project with a target SQL Server Version of 2016 to VS 2022 with a target SQL Server Version of 2022. I am having a lot of problems, I am trying to import one package at a time. I change the target version of the project to SQL Server 2022 and save it and it seems to run ok. However, every time I open the project it prompts me and says
"TITLE: Microsoft Visual Studio
You are about to change the TargetServerVersion property to SQL Server 2022 of this project. If your project contains extensions that are not supported nor installed in SQL Server 2022, your packages may not be run properly.
It is highly recommended to:
Do you want to make the change now?
BUTTONS:
&Yes
&No
"
I select "Yes", but it doesn't seem to save it because every time I open the project it prompts me.
Also, when I right click on a package, all the menu items are duplicated
What am I doing wrong? What is the best method to upgrade? Thank you.
![](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(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Actually, I figured out the TargetVersion part, it kept prompting me because I had configurations that were still pointing to SQLServer2016. I had to open the project file and remove them manually, removing them from the project within VS didn't seem to work.
Actually, I change the target version and it updates all the packages. I hit save all, close the solution and reoload it and it still prompts me to upgrade. Why?
![](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(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi @Andrew Hopkinson
I found this link for you, hope it helps.
If my answer is helpful to you, please mark my answer as "Accept Answer", thanks for your feedback.
Best regards,
Aniya