Version differences and selections for Microsoft SQL Server _mssql

For people who are new to the SQL database, there are a few questions about the SQL version of the problem, but they are too lazy to study it carefully. Although the problem is simple, but the impact is not small.

Version differences

SQL Server 2000 has four versions: Enterprise/Standard/personal/development
The Enterprise and Standard editions need to be installed on the server operating system.
such as Windows NT server/windows server/windows 2003 Server, etc.
The personal version needs to be installed on the personal operating system,
such as Windows98/windows professional/windows XP home/windows XP Professional, etc.
The development version can be installed on any Microsoft operating system.

SQL Server 2000 Enterprise Edition

Used as a production database server. Supports all available features in SQL Server 2000 and scales to the level of performance required to support the largest web site and enterprise online transaction processing (OLTP) and data warehousing systems.

SQL Server 2000 Standard Edition

Used as a database server for a small workgroup or department.

SQL Server 2000-person Edition

For mobile users who sometimes disconnect from the network, but the applications they run require SQL Server data storage. Personal editions are also used when running stand-alone applications that require local SQL Server data storage on a client computer.

SQL Server 2000 Development Edition

For programmers to develop applications that use SQL Server 2000 as a data store. While the development version supports all the features of the Enterprise Edition, enabling developers to write and test applications that can use these features, the development version can only be used as a development and test system and cannot be used as a production server.

SQL Server Windows CE Edition
Use the Microsoft®sql server 2000™WINDOWS®CE version (SQL Server CE) to store data on a Windows CE device. Can replicate data in any version of SQL Server 2000 to keep Windows CE data synchronized with the primary database.

SQL Server 2000 Enterprise Evaluation Edition

A full-featured version that can be downloaded free of charge from the Web. For evaluation of SQL Server functionality only; 120 days after downloading the version will stop running.

In addition to these versions of SQL Server 2000, the SQL Server Desktop Engine component allows application developers to distribute copies of the SQL Server 2000 relational database engine with their applications. Because the functionality of the database engine in SQL Server Desktop Engine is similar to the database engine in each version of SQL Server, the Desktop Engine database cannot be larger than 2 GB.

On SQL Server Books Online. Version compatibility: overview

The following is a simple comparison of these versions:

SQL Server includes Enterprise Edition, Standard Edition, Personal Edition, development version, Desktop Engine (MSDE), Evaluation Edition, CE Edition

1. Evaluation version for evaluation, CE version for Windows CE, not much to say

2. From the functional, enterprise and development version is a pair, Standard Edition and Personal Edition is a pair. The Enterprise Edition and Development Edition are mainly used for large users, can support more CPU, memory, can support cluster (Cluster), log transfer (logs shipping), parallel DBCC, create index in parallel, indexed view and other advanced functions.

3. From the installation view, the Enterprise Edition and Standard Edition are a pair, the Personal Edition, the development version and the Desktop Engine are a group, the Enterprise Edition and the Standard Edition can only install on the Windows Server Edition (NT, 2000, 2003), the Personal Edition, the development version and the Desktop Engine may install in the more system (including NT Workstation, professional, XP and so on. 98 can only install a personal version or Desktop Engine, but the Desktop Engine data users can not exceed 2G).

4. Use the Enterprise version, Standard Edition or Desktop Engine, (personal version, development version for the corresponding Standard Edition, Enterprise Edition development).