Skip to content
Knowledge Base
Česky

Database · LocalDB

SQL LocalDB: Upgrade to 2022 (15.0.2000)

Robert Haken 1 min read Markdown ↓

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:

  1. 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
    1. Run the installer and select “Download Media”.
    2. Select “LocalDB” + click Download.
  2. Before running the SqlLocalDB.msi installer, delete your current MSSQLLocalDB instance:
sqllocaldb stop MSSQLLocalDB
sqllocaldb delete MSSQLLocalDB
  1. Run the new SqlLocalDB.msi (2022) installer. It will create a new MSSQLLocalDB instance.
  2. RESTART YOUR PC! (Otherwise MS SQL Management Studio will still tell you you have an old version running, etc. etc.)
  3. Now you can re-attach your original databases one by one using SQL Server Management Studio (RClick + Attach…)
  4. Done.
LocalDB
Robert Haken · HAVIT Software Architect, Founder at HAVIT, Microsoft MVP - ASP.NET/IIS.
Has 53 articles in the knowledge base. All articles by this author →
HAVIT
Service · havit.eu We build custom .NET and Blazor apps for clients, too
Read next
Database · 1 min

SQL LocalDB: Upgrade to 2019 (15.0.2000)

 Database · 1 min

SQL: Index statistics update date
5 comments

  4. did not work, stil lstuck at 15.0 for the local db even trough the new version 16 is instaled and ready

    Reply

    1. okay after trying multiple times I noticed I fergot to drop my old database via

      sqllocaldb stop MSSQLLocalDB

      sqllocaldb delete MSSQLLocalDB

      now everything works perfectly, thanks

      Reply

Leave a reply