For me it was quite confusing to find the 2022 version of LocalDB and it is not a streamline process to upgrade your local default instance.
The easiest way to upgrade your LocalDB instance to 2022 is:
- Download the LocalDB 2022 installer by using the SQL Server Express installer.
https://download.microsoft.com/download/5/1/4/5145fe04-4d30-4b85-b0d1-39533663a2f1/SQL2022-SSEI-Expr.exe
- Run the installer and select “Download Media”.
- Select “LocalDB” + click Download.
- Before running the SqlLocalDB.msi installer, delete your current MSSQLLocalDB instance:
sqllocaldb stop MSSQLLocalDB
sqllocaldb delete MSSQLLocalDB
- Run the new SqlLocalDB.msi (2022) installer. It will create a new MSSQLLocalDB instance.
- RESTART YOUR PC! (Otherwise MS SQL Management Studio will still tell you you have an old version running, etc. etc.)
- Now you can re-attach your original databases one by one using SQL Server Management Studio (RClick + Attach…)
- Done.