HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Differences between the different installers of SQL Server 2014 Express

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
theexpresssqldifferencesinstallersdifferentbetweenserver2014

Problem

I'm trying to understand the differences between the different installers of SQL Server 2014 Express. If you are able to tell me whatever you can or find documentation on them, I'd appreciate it.

https://www.microsoft.com/en-us/download/confirmation.aspx?id=42299

Express 32BIT WoW64\SQLEXPR32_x86_ENU.exe
Express 32BIT\SQLEXPR_x86_ENU.exe
Express 64BIT\SQLEXPR_x64_ENU.exe
ExpressAdv 32BIT\SQLEXPRADV_x86_ENU.exe
ExpressAdv 64BIT\SQLEXPRADV_x64_ENU.exe
ExpressAndTools 32BIT\SQLEXPRWT_x86_ENU.exe
ExpressAndTools 64BIT\SQLEXPRWT_x64_ENU.exe
LocalDB 32BIT\SqlLocalDB.msi
LocalDB 64BIT\SqlLocalDB.msi
MgmtStudio 32BIT\SQLManagementStudio_x86_ENU.exe
MgmtStudio 64BIT\SQLManagementStudio_x64_ENU.exe

Solution

-
Express 32BIT WoW64\SQLEXPR32_x86_ENU.exe


This is for installing the 32-bit version of SQL Server Express, just the engine, on a 64-bit OS in WoW64 mode. WoW64 mode is described in excruciating detail here.

-
Express 32BIT\SQLEXPR_x86_ENU.exe


This is for installing the 32-bit version of SQL Server Express, just the engine, on a 32-bit OS.

-
Express 64BIT\SQLEXPR_x64_ENU.exe


This is for installing the 64-bit version of SQL Server Express, just the engine, on a 64-bit OS.

-
ExpressAdv 32BIT\SQLEXPRADV_x86_ENU.exe


This is for installing a 32-bit engine and advanced services on a 32-bit operating system. "Advanced services" are explained here.

-
ExpressAdv 64BIT\SQLEXPRADV_x64_ENU.exe


This is for installing a 64-bit engine and advanced services on a 64-bit operating system. "Advanced services" are explained here.

-
ExpressAndTools 32BIT\SQLEXPRWT_x86_ENU.exe


This is for installing a 32-bit engine and tools (most importantly SSMS and Profiler) on a 32-bit operating system. "Express With Tools" is explained here.

-
ExpressAndTools 64BIT\SQLEXPRWT_x64_ENU.exe


This is for installing a 64-bit engine and tools (most importantly SSMS and Profiler) on a 64-bit operating system. "Express With Tools" is explained here.

-
LocalDB 32BIT\SqlLocalDB.msi


This is for installing LocalDB on a 32-bit operating system. LocalDB is described here.

-
LocalDB 64BIT\SqlLocalDB.msi


This is for installing LocalDB on a 64-bit operating system. LocalDB is described here.

-
MgmtStudio 32BIT\SQLManagementStudio_x86_ENU.exe


This is for installing a standalone Management Studio on a 32-bit operating system.

-
MgmtStudio 64BIT\SQLManagementStudio_x64_ENU.exe


This is for installing a standalone Management Studio on a 64-bit operating system.

Context

StackExchange Database Administrators Q#122707, answer score: 8

Revisions (0)

No revisions yet.