Differences between MS SQL Server 2012 Express
On Microsoft.com you can download Microsoft® SQL Server® 2012 Express. It’s a free software for home use – education, tests or something like this. When you click "Download" link on a page http://www.microsoft.com/en-US/download/details.aspx?id=29062, you can see a list of versions for downloading. Which one to choose?
SQLEXPR: MS SQL Express, just the engine
SQLEXPRWT: MS SQL Express with Tools = engine and Management studio
SQLEXPRADV: Express with advanced services = engine, Management studio, additional features (fulltext search, reporting services, integration services, SQL Server Data Tools etc.)
More information you can find in the table below.
Features | SQLEXPR | SQLEXPRWT | SQLEXPRADV |
SQL Server Core |
* |
* |
* |
SQL Server Management Studio |
- |
* |
* |
Distributed Replay – Admin Tool |
- |
* |
* |
LocalDB |
- |
* |
* |
SQL Server Data Tools (SSDT) |
- |
- |
* |
Full-text and semantic search |
- |
- |
* |
Specification of language in query |
- |
- |
* |
Some of Reporting services features |
- |
- |
* |