| SQL Server 2000 contains many features that help businesses manage and analyze data, but one "feature" that might not be so obvious is the selection of SQL Server 2000 editions. There are several different editions to choose from. That might seem like a lot of different products to worry about, but understanding the differences and appropriate uses for these various editions is actually quite simple. |
| The different editions are designed to accommodate the unique performance, runtime, and price requirements of organizations and individuals. For example, your organization may require not only that its database and analysis solution run on the largest, most powerful computers in your company's data center, but also that this solution be able to "scale down" to desktops, laptops, and even devices like the Pocket PC. SQL Server 2000 achieves this goal while maintaining maximum application compatibility across platforms. Understanding these options allows organizations to make the most cost-effective and technically appropriate choice for their particular needs. |
| Click on one of the editions below to learn more about the differences among the various editions of SQL Server 2000, and how you can save time and money by choosing the right one for the job. |
|
| |
|
| SQL Server 2000 Standard Edition |
|
| |
| Standard Edition is the data management and analysis platform for small and medium-sized organizations. It includes the essential functionality needed for e-commerce, data warehousing, and line-of-business solutions. Standard Edition’s integrated business intelligence features provide organizations with the capabilities needed to manage and analyze their data. Reporting Services provides robust business intelligence features. Analysis Services provides data mining features and the core OLAP (On-Line Analytical Processing) functionality. |
|
| |
|
| SQL Server 2000 Workgroup Edition |
|
| |
| Workgroup Edition is the data management solution for small organizations or workgroups within larger entities. It includes all of the core database features needed for data management in an easy-to-use, simple to manage, and affordable package. Workgroup Edition is ideal for the small organization for line-of-business (LOB), local data store, and e-commerce solutions. All of the management features that make SQL Server easy to support and simple to manage are included in Workgroup Edition. |
|
| |
|
| SQL Server 2000 Personal Edition |
|
| |
| SQL Server 2000 Personal Edition is ideal for mobile users who spend some of their time disconnected from the network but run applications that require SQL Server data storage, and for stand-alone applications that require local SQL Server data storage on a client computer. This edition is functionally equivalent to the Standard Edition, with the following exceptions: It includes a concurrent workload governor that limits its scalability; performance degrades when more than five Transact-SQL batches are executed concurrently. It can use a maximum of two processors in an SMP computer (only one processor if running Windows 98 or Windows Millennium Edition). It cannot act as a transactional replication publisher (subscriber only). |
|
| |
|
| SQL Server 2000 Developer Edition |
|
| |
| This edition allows developers to build any type of application on top of SQL Server. It includes all of the functionality of Enterprise Edition but with a special development and test end-user license agreement (EULA) that prohibits production deployment (for complete details, see the SQL Server 2000 Developer Edition EULA at http://www.microsoft.com/sql. For maximum flexibility during development, it will install to the aforementioned server operating systems as well as Windows 2000 Professional and Windows NT Workstation 4.0. |
|
| |
|
| SQL Server 2000 Evaluation Edition |
|
| |
| SQL Server 2000 Evaluation Edition (also known as SQL Server 2000 Enterprise Evaluation Edition) is a time-limited version of SQL Server 2000 Enterprise Edition that is licensed for demonstration, testing, examination, and evaluation for a period of 120 days. This means that Evaluation Edition is not for production use; solutions must be deployed on SQL Server 2000 Enterprise or Standard Edition. Evaluation Edition will not function after the 120-day limit has been reached. The only cost for this edition is a minimal shipping and handling fee. The advantage of the Evaluation Edition is that you can evaluate the complete set of features in SQL Server 2000, which can be useful whether you are already familiar with SQL Server or are completely new to the product. |
|
| |
|
| SQL Server 2000 Windows CE Edition |
|
| |
| Microsoft SQL Server 2000 Windows CE Edition (SQL Server CE) is the compact database for rapidly developing applications that extend enterprise data management capabilities to devices. SQL Server CE is a full-fledged member of the SQL Server 2000 family, with tools, application programming interfaces (APIs), and SQL grammar that developers and database administrators with existing SQL Server skills will recognize. SQL Server CE is the only edition of SQL Server 2000 that provides relational database management capabilities on Windows CE-based devices. |
|
| |
|
| SQL Server 2000 Desktop Edition |
|
| |
SQL Server 2000 Desktop Engine is the successor to Microsoft Data Engine (MSDE) 1.0, which was based on SQL Server version 7.0. As such, SQL Server 2000 Desktop Engine is often referred to as MSDE 2000. The SQL Server 2000 Desktop Engine is not related to SQL Server 7.0 Desktop Edition. Probably the most significant characteristic of the Desktop Engine is that it is a redistributable version of the SQL Server relational database engine. Third-party software developers can include it in their applications that use SQL Server to store data. The SQL Server 2000 Desktop Engine is made available as a set of Windows Installer merge modules that can be included in the application setup. The Desktop Engine is an ideal embedded or offline data store, because it is easy to install and has the smallest footprint of any edition of SQL Server 2000. The SQL Server 2000 Desktop Engine does not include graphical management tools; the application distributing the engine is usually coded to perform any needed database administration.
|
|
