SQL2005 version of the difference between the detailed (enterprise,development,workgroup,standard,express)

Source: Internet
Author: User
Tags query versions management studio microsoft website
development|enterprise|express|sql2005|standard|workgroup| Difference | The explanation had always thought it was his own machine, or something, but just once again in the official SQL2005 Express, in the company installed on the machine, found and the home is no different. Depressed tight, online Amoy a moment before it dawned. Really want to dozens, without the "Enterprise Manager" and "Query Analyzer", that also provides download why? Is there a bird to use?!!!!!


The SQL2005 is divided into five versions, as listed below:

1.Enterprise (Enterprise Edition)
2.Development (development version)
3.Workgroup, (Working Group edition)
4.Standard, (Standard Edition)
5.Express. (Well, let's call it a simple version)

Which edition should we use in these editions? This is one of the most frequently asked questions by many beginners and SQL2005.

Simply compare the three versions of Enterprise, Development and Express: Functional, Enterprise and Development. The difference between the two, in addition to the different mandates, the main difference is:

The Enterprise version of the database engine can only be installed in Win2003server (or other server).

If you want to install on the Windows XP Pro system, you should install the SQL2005 Development version (development version).

Note: Someone asked what is the "database engine." Well, database engine is the core of SQL2005, is the main database management function module. Without it, it is not a database management system.

Many people download the SQL2005 Express version, because it is free and can be downloaded directly from the Microsoft website. However, in addition to supporting less memory, the main thing is that it lacks the equivalent of SQL2000 "Enterprise Manager" and "Query Analyzer."

Note: the "Enterprise Manager" and "Query Analyzer" SQL2000 under the SQL2005 have been combined into one, called Management Studio.

So if you are a beginner and if you just want to learn at home, if your environment is Windows XP Pro, then you should choose SQL2005 Development (development version) instead of SQL2005 Enterprise (Enterprise Edition) or SQL2005 Express (simple version).


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.