To obtain the offline installer for SQL Server Express LocalDB, you can follow these steps:
- Download the SQL Server Express installation media: LocalDB is included as a feature in the SQL Server Express installation. You need to choose the Express Advanced or the LocalDB package during the installation process.
- For SQL Server 2022, 2019, 2017, and 2016, you can find the respective installation media on the Microsoft website.
- Locate the LocalDB installer: The LocalDB installer,
SqlLocalDB.msi, is found in the installation media under the path: <installation_media_root>\<LCID>_ENU_LP\x64\Setup\x64. Here, LCID is a locale identifier. For example, for the en-US locale, the LCID value is 1033.
- Install via Visual Studio Installer: Alternatively, you can install LocalDB through the Visual Studio Installer as part of the Data Storage and Processing workload, the ASP.NET and web development workload, or as an individual component.
Currently, there is no separate download link for x64 and x86 versions of the LocalDB installer; it is typically included in the SQL Server Express installation package. You may need to ensure that you are selecting the appropriate architecture during the installation process.
If you need both architectures, you would typically install the x64 version on a 64-bit machine, which can also run 32-bit applications, while the x86 version is for 32-bit machines.
References: