I’ve been using the SSMS preview for v21. This is the next evolution of SSMS, where the VS shell is finally being updated. For many of us, SSMS has been using an old version of the Visual Studio shell as its basis for development. It’s a locked down version, which is limited what’s possible in SSMS. Redgate and a few other companies have hacked in tools like SQL Prompt and SQL Source Control, but the number of extensions.
In any case, this post looks at the upgrade to preview 6. I was on 4 on this machine, and I noticed a message when (returned home and ) started SSMS.
Just like v19 and v20, this appears in the lower right corner. However, in this case, it’s showing a VS 2022 update.
When I click the update on close, and close SSMS, I see a UAC dialog and then the VS Installer. The download and install starts right away, in the same way that any VS update comes down.
When this finishes, no download, nothing for me to do, I see things updated.
And I’m updated. When I started, I got the question about testing the new connection dialog, which I agreed to, but forgot to screenshot. In any case, I can now do more testing with this new version to be sure it’s working well.