SQL Server Management Studio Express (SQLManagementStudio) Choose either LocalDB or Express depending on your needs above. This package contains everything needed to install and configure SQL Server as a database server including the full version of SQL Server 2014 Management Studio with SP3.Best suited to accept remote connections or administer remotely. It can be bundled with Application and Database Development tools like Visual Studio and or embedded with an application that needs local databases.Įxpress edition includes the SQL Server database engine only. Use this if you need a simple way to create and work with databases from code.
LocalDB is a lightweight version of Express that has all its programmability features, yet runs in user mode and has a fast, zero-configuration installation and short list of pre-requisites.For a complete list of supported features in SQL Server Management Studio, see Features in SQL Server Management Studio. The SQL Server 2014 SP3 Express release includes the full version of SQL Server 2014 Management Studio with SP3 instead of SQL Server 2014 Management Studio Express. Microsoft SQL Server 2014 Express with SP3 are a free, feature-rich editions of SQL Server that is ideal for learning, developing, powering desktop, web & small server applications, and for redistribution by ISVs.
