Differences and selection of Microsoft SQL Server versions
Microsoft SQLServer version differences and selection
For new users who are new to SQL databases, there are many questions about SQL versions, but they are too lazy to study them carefully. Although the problem is simple, the impact is not small.
Version differences
SQL Server 2000 has four editions: Enterprise Edition/Standard Edition/individual edition/Development Edition
The Enterprise Edition and Standard Edition must be installed on the server operating system,
For example, Windows NT Server/Windows 2000 Server/Windows 2003 Server
The Personal Edition must be installed on the personal operating system,
For example, Windows 98/Windows 2000 Professional/Windows XP Home/Windows XP Professional
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 functions of SQL Server 2000, and supports scaling based on the performance levels required by the largest Web site and enterprise online transaction processing (OLTP) and data warehouse systems.
SQL Server 2000 Standard Edition
Used as a database server of a small working group or department.
SQL Server 2000 Personal Edition
For mobile users, these users are sometimes disconnected from the network, but the running applications require SQL Server data storage. The Personal Edition is also used to run independent applications that require local SQL Server data storage on the client computer.
SQL Server 2000 Development Edition
For programmers to develop applications that use SQL Server 2000 as data storage. Although the development edition supports all the features of the Enterprise Edition, developers can write and test applications that can use these features, the development edition can only be used as a development and testing system, cannot be used as a production server.
SQL Server 2000 for Windows CE
Use Microsoft®SQL Server 2000™Windows®SQL Server CE is used to store data on Windows CE devices. You can use any version of SQL Server 2000 to copy data so that Windows CE data can be synchronized with the master database.
SQL Server 2000 Enterprise Evaluation Edition
A complete version of the free download function from the Web. It is only used to evaluate the SQL Server function. The version will stop running after 120 days of download.
In addition to these versions of SQL Server 2000, the SQL Server 2000 Desktop Engine component allows application developers to use their applications to distribute copies of the SQL Server 2000 relational database Engine. Because the function of the Database Engine in SQL Server 2000 Desktop Engine is similar to that in SQL Server versions, the database size of the Desktop Engine cannot exceed 2 GB.
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 edition, Desktop Engine (MSDE), evaluation edition, and CE Edition
1. The evaluation version is used for evaluation, and the CE version is used for Windows CE.
2. In terms of functions, the Enterprise Edition and the development edition are a pair, and the Standard Edition and the individual edition are a pair. Enterprise Edition and Development edition are mainly used for large users. They can support more CPU and memory, Cluster, log shipping, parallel DBCC, and concurrent index creation, index view and other advanced functions.
3. from the installation perspective, the Enterprise Edition and Standard Edition are one-on-one, Personal Edition, development edition, and Desktop Engine. The Enterprise Edition and Standard Edition can only be installed on Windows Server Edition (NT, 2000,200 3, personal Edition, development edition, and Desktop Engine can be installed on more systems (including NT Workstation, 2000 professional, XP, etc. 98 only personal edition or desktop engine can be installed, but the Desktop Engine data owner cannot exceed 2 GB ).
4. Use the Enterprise Edition, Standard Edition, or Desktop Engine when running (Personal Edition and Development edition are used for development corresponding to the Standard Edition and Enterprise Edition respectively ).
