Type: SQL Server; issue: version; Result: SQL Server version differentiated

Source: Internet
Author: User
Tags management studio sql server management sql server management studio sql server express

LocalDB (SQLLOCALDB)
LocalDB is a lightweight version of Express, which has all the programmability features, but runs in user mode and features a fast 0 configuration installation and fewer prerequisites required. You can use this version if you need to create and use a database from code in a simple way. This version can be bundled with application and database development tools such as Visual Studio or embedded with applications that require a local database.
Express (sqlexpr)
The Express version contains only the SQL Server database engine. It is best suited to situations where you need to accept remote connections or manage remotely.
Express with Tools (SQLEXPRWT)
This package contains everything you need to install and configure SQL Server as a database server, including the full version of SQL Server Management Studio SP1. Choose LocalDB or Express according to your needs.
SQL Server Management Studio Express (Sqlmanagementstudio)
This version does not contain a database and contains only tools for managing instances of SQL Server (including LocalDB, SQL Express, SQL Azure, full version of SQL Server Management Studio SP1, and so on). You can use this version if you have a database and you only need administrative tools.
Express with Advanced Services (SQLEXPRADV)
This package contains all the components of SQL Server Express, including the full version of SQL Server Management Studio SP1. The download size of this package is larger than the "with tools" version because it also contains both full-text search and Reporting Services.

Type: SQL Server; issue: version; Result: SQL Server version differentiated

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.