Comparison of three versions of Ms-sql Server 2005 _mssql

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).