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 2012 SP1 Express release includes the full version of SQL Server 2012 Management Studio with SP1 instead of SQL Server 2012 Management Studio Express. Microsoft SQL Server 2012 Express with SP1 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.
