9

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
6

Did you refer to Details ? It covers all the details.

MgmtStudio 32BIT\SQLManagementStudio_x86_ENU.exe

MgmtStudio 64BIT\SQLManagementStudio_x64_ENU.exe

These are standalone installations for SSMS - a GUI tool to manage sql server.

enter image description here

7
  • 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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.