Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What is the difference between SQL Server 2012 Express versions?

I've come across this page http://www.microsoft.com/en-us/download/details.aspx?id=29062 and I am a bit confused about the different versions here.

So I would like to know what is the difference between

  • SQLEXPR_x64_ENU.exe
  • SQLEXPRADV_x64_ENU.exe
  • SQLEXPRWT_x64_ENU.exe
like image 532
Rushino Avatar asked Oct 17 '22 01:10

Rushino


People also ask

What is the difference between SQL Server and Express?

SQL Express is free, but requires a bit more RAM to perform well. SQL Standard has a licence costs but Your Office Anywhere are able to significantly reduce the licence burden for customers by using data centre licences and running multiple secure instances of SQL on multi-tenanted servers.

What is the difference between SQL Express and SQL Express advanced?

Express core: It installs the SQL Server database engine only. Express advanced: If you require additional SSRS and full-text service, choose the advanced option. LocalDB: The LocalDB is a lightweight express edition that includes programmability features and can run in user mode.

What are the limitations of Microsoft SQL Server Express editions?

Express edition limitations Microsoft SQL Server Express has a 10 GB maximum database size and other important limits. High load scenarios are not supported by Express. Symptoms can include database connection errors. Express has a "LocalDB" preset.

What is SQL Express 2012?

29.6 MB. 964.4 MB. + More - Less. Microsoft SQL Server 2012 Express with SP3 is a free, feature-rich edition of SQL Server that is ideal for learning, developing, powering desktop, web & small server applications, and for redistribution by ISVs.


1 Answers

Scroll down on that page and you'll see:

Express with Tools (with LocalDB) Includes the database engine and SQL Server Management Studio Express)
This package contains everything needed to install and configure SQL Server as a database server. Choose either LocalDB or Express depending on your needs above.

That's the SQLEXPRWT_x64_ENU.exe download.... (WT = with tools)


Express with Advanced Services (contains the database engine, Express Tools, Reporting Services, and Full Text Search)
This package contains all the components of SQL Express. This is a larger download than “with Tools,” as it also includes both Full Text Search and Reporting Services.

That's the SQLEXPRADV_x64_ENU.exe download ... (ADV = Advanced Services)


The SQLEXPR_x64_ENU.exe file is just the database engine - no tools, no Reporting Services, no fulltext-search - just barebones engine.

like image 201
marc_s Avatar answered Oct 19 '22 15:10

marc_s