April 6, 2021 at 12:00 am
Comments posted to this topic are about the item LocalDB Install
April 9, 2021 at 2:54 pm
Hi Steve. The "correct" answer and information provided in this question are not exactly correct and should be updated.
The current "correct" answer:
It is an option if I get the Express for Visual Studio installers
is not incorrect, but there are two others that are also not entirely incorrect.
The first is:
It is already installed with developer edition.
While this is technically incorrect as LocalDB is not "installed" with Developer edition, the installer is, in fact, distributed with Developer edition (as well as with Enterprise, Standard, and I assume also Web, editions; just not with Express Core -- the Express-only option in the Express installer). To be fair, most people are probably unaware of this as it's another instance of incomplete / misleading documentation. I have submitted a PR to fix this:
Add missing installation source for Express LocalDBÂ #6273
The SqlLocalDB.msi installer can be found in the following location in most installation media (again, except for Express Core) in the {installation_media_root}\{LCID}_ENU_LP\x64\Setup\x64 folder. LCID is a locale identifier or language code. For example, an LCID value of 1033 refers to the en-US locale.
The second not entirely incorrect answer:
Download the standalone LocalDB installed form Microsoft
is only incorrect in that Microsoft does not publicly advertise the URL. However, such a URL (for the standalone msi) does exist and is:
https://download.microsoft.com/download/7/c/1/7c14e92e-bdcb-4f89-b7cf-93543e7112d1/SqlLocalDB.msi
That URL, and others, can be found at:
http://downloadsqlserverexpress.com (by Scott Hanselman)
Also, most versions of LocalDB (all but 2016 as far as I can tell) can be found via Chocolatey (unofficially, of course):
https://community.chocolatey.org/packages?q=localdb
The following package is currently for SQL Server Express LocalDB 2017, but the 2019 version is in moderation (the Version History shows that it was updated a week ago so perhaps it will be fixed / approved soon):
https://community.chocolatey.org/packages/sqllocaldb
Of course, looking at the install script for that package, it's just pulling from the same download.microsoft URL that I posted above.
Take care,
Solomon...
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply