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. (Estimate and call it a simple version)
Which version should we use in these editions? This is the most frequently asked question by many novice SQL2005.
I'll simply compare the three versions of Enterprise, Development and Express:
In function, the Enterprise version and the Development version of the function is exactly the same. 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 Sql2005development version (development version).
Note: Some people ask, what is the "database Engine"? The database engine is the core of SQL2005, and is the most important module of database management function. Without it, it is not a database management system.
Many people download the sql2005express 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
It lacks the equivalent of "Enterprise Manager" and "Query Analyzer" under SQL2000.
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 sql2005development (development version) instead of Sql2005enterprise (Enterprise Edition) or sql2005express (simple version).
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.