winget upgrade of Microsoft.SQLServerManagementStudio from v19.3 to 20.0 fails

[pamanes]

winget upgrade of Microsoft.SQLServerManagementStudio from v19.3 to 20.0 fails

[github-actions]

Hi I'm an AI powered bot that finds similar issues based off the issue title.

Please view the issues below to see if they solve your problem, and if the issue describes your problem please consider closing this one and thumbs upping the other issue to help us prioritize it. Thank you!

Open similar issues:

• installed SQLServerManagementStudio in both versions, winget command for SSMS is don't work (#3055), similarity score: 0.77

Closed similar issues:

• Improper versions being reported by "upgrade" - Sql Server Management Studio (#828), similarity score: 0.78
• After Upgrading SQL Server Management Studio winget see three of it's packages as out-of-date. (#2269), similarity score: 0.77
• Upgrade doesn't work for Microsoft.VisualStudio.2019.BuildTools (#1324), similarity score: 0.75
• Multiple same name packages appeared right after the package upgrade (#2152), similarity score: 0.75

Note: You can give me feedback by thumbs upping or thumbs downing this comment.

[Trenly]

Can you run winget list "SQL Server"? This package is known to install side by side, causing the old version to still be detected as being outdated even though the newer version is also installed

[rumplin]

I have the same issue (But I manually already upgraded to version 20).
winget still shows there is an update:

winget update
Name                                          Id                                  Version   Available Source
------------------------------------------------------------------------------------------------------------
Microsoft SQL Server Management Studio - 19.3 Microsoft.SQLServerManagementStudio 19.3      20.0      winget
1 upgrades available.
1 package(s) have version numbers that cannot be determined. Use --include-unknown to see all results.

winget list "SQL Server"
Name                                           Id                                     Version     Available Source
------------------------------------------------------------------------------------------------------------------
Microsoft SQL Server 2019 LocalDB              {36E492B8-CB83-4DA5-A5D2-D99A8E8228A1} 15.0.4153.1
Microsoft ODBC Driver 17 for SQL Server        {57B9F896-DE52-4CFA-B7DE-9EFD00A1E020} 17.10.5.1
Microsoft System CLR Types for SQL Server 2019 Microsoft.CLRTypesSQLServer.2019       15.0.2000.5           winget
Microsoft OLE DB Driver for SQL Server         {EBC362C3-E2BD-41A6-BC10-F07D52F1509E} 18.6.7.0
Microsoft SQL Server Management Studio - 20.0  Microsoft.SQLServerManagementStudio    20.0                  winget
Microsoft SQL Server Management Studio - 19.3  Microsoft.SQLServerManagementStudio    19.3        20.0      winget

winget update --id Microsoft.SQLServerManagementStudio --exact --accept-source-agreements --silent --disable-interactivity --accept-package-agreements --force --include-unknown
No installed package found matching input criteria.

I can manually uninstall 19.3, but the idea was to use winget to do the upgrade not intervene manually.

[denelon]

We're doing some work for packages that install side-by-side. I'm hoping to get a build out in the next few days for WinGet 1.8-preview so users can test with the experimental feature.

[denelon]

We've been working on the side-by-side scenarios. You could try the latest release and enable the experimental feature on:

• https://github.com/microsoft/winget-cli/releases/tag/v1.8.924-preview

Please provide feedback at:

• #4281

[Zulgrib]

If the software is meant to be installed side by side, maybe it needs its own ID and shouldn't be shown as an update?