Explain the differences and selection of SQL Server versions

Source: Internet
Author: User

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

Enterprise and standard editions must be installed on Server operating systems, such as Windows NT Server, Windows 2000 Server, and Windows 2003 Server.

The Personal Edition must be installed on a personal OS, such as 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.

Version compatibility

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 can only install Personal Edition or desktop engine, but the Desktop Engine database 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 ).

Differences between Standard Edition and Enterprise Edition

1. Does the system support the MSC cluster?

2. Whether full-text indexing is supported

3. Whether the distributed partition view is supported

4. Support for log Transmission

5. Does the index view support CPU usage?

The Enterprise Edition provides the highest availability, stability, and concurrency. The individual edition and MSDE are hard-coded to minimize the performance of concurrent users after more than five.

Standard Edition

The database engine function lacks a Failover cluster (up to four nodes) supports failover, log transfer, parallel DBCC, parallel create index, enhanced pre-read and scanning, INDEX view, combined database Server, and system region network (SAN) graphical utility that supports language settings, for Analysis Services, user-defined OLAP partition, partition wizard, link OLAP multi-dimensional dataset, ROLAP dimension support, HTTP Internet support, computing unit, write-back dimension support, ultra-large dimension, real-time OLAP, distributed partitioned multi-dimensional dataset, SMP with a maximum of four CPUs is supported in win2000, and SMP with a maximum of eight CPUs in NT (Enterprise Edition)

Buy 10 licenses for up to 20 users (generally limit the number of concurrent users, and the number of connections is determined by the OS)

Enterprise Edition

Used as a production database server. Supports all available functions of SQL SERVER 2000 and scales according to the performance levels required by OLTP and data warehouse systems for the largest Web sites and enterprise online transaction processing.

Read more]

  1. Microsoft TechEd 2009 announces SQL Server R2's Christmas release
  2. Topic: SQL Server 2008 deep application
  3. Upgrading and deploying SQL Server 2008

Related Article

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.