Editions of SQL Server 2000
Microsoft® SQL Server™ 2000 is available in these editions:
SQL Server 2000 Enterprise Edition
Used as a production database server. Supports all features available in SQL Server 2000, and scales to the performance levels required to support the largest Web sites 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 Personal Edition
Used by mobile users who spend some of their time disconnected from the network but run applications that require SQL Server data storage. Also used when running a stand-alone application that requires local SQL Server data storage on a client computer.
SQL Server 2000 Developer Edition
Used by programmers developing applications that use SQL Server 2000 as their data store. Although the Developer Edition supports all the features of the Enterprise Edition that allow developers to write and test applications that can use the features, the Developer Edition is licensed for use only as a development and test system, not a production server.
SQL Server 2000 Windows CE Edition
Microsoft® SQL Server 2000™ Windows® CE Edition (SQL Server CE) is used as the data store on Windows CE devices. Capable of replicating data with any edition of SQL Server 2000 to keep Windows CE data synchronized with the primary database.
SQL Server 2000 Enterprise Evaluation Edition
Full-featured version available by a free download from the Web. Intended only for use in evaluating the features of SQL Server; this version will stop running 120 days after downloading.
In addition to these editions of SQL Server 2000, the SQL Server 2000 Desktop Engine is a component that allows application developers to distribute a copy of the SQL Server 2000 relational database engine with their applications. While functionality of the database engine in the SQL Server 2000 Desktop Engine is similar to the database engine in the SQL Server Editions, the size of Desktop Engine databases cannot exceed 2 GB.
Both the SQL Server 2000 Personal Edition and SQL Server 2000 Desktop Engine have a concurrent workload governor that limits the performance of the database engine when more than 5 batches are executed concurrently. For more information about the concurrent workload governor, see SQL Server 2000 Databases on the Desktop.
Upgrading From One Edition to Another
These are the supported upgrade paths between the editions and versions of SQL Server 2000:
- SQL Server 2000 Personal Edition to either SQL Server 2000 Enterprise Edition or SQL Server 2000 Standard Edition.
- SQL Server 2000 Standard Edition to SQL Server 2000 Enterprise Edition.
- SQL Server 2000 Desktop Engine to SQL Server 2000 Enterprise Edition or SQL Server 2000 Standard Edition.