SQL Server Versions

As you are probably aware by now, Microsoft SQL Server is a relational database management system for storing, analyzing, and reporting data. Currently, seven versions of Microsoft SQL Server are available with SQL Server 2000, and the same or similar versions will probably be available when SQL Server 2005 is released. Each is briefly described here:

□ SQL Server 2000 Enterprise Edition—This is the most comprehensive version of SQL Server 2000 and supports all the SQL Server 2000 features. This version is most appropriate for large organizations that are required to manage immense amounts of data quickly and efficiently.

□ SQL Server 2000 Standard Edition—This version of SQL Server 2000 supports many of the available features, but doesn't support the features that enable management of immense amounts of data quickly and efficiently. This version is primarily for small- or medium-sized organizations that do not have the complex database requirements of a large organization. SQL Server 2000 Standard Edition is still an extremely powerful version of SQL Server and supports Analysis Services (with a few exceptions), Replication, Full-Text Search, Data Transformation Services, English Query, and other advanced SQL Server features.

□ SQL Server 2000 Personal Edition—This version of SQL Server 2000 supports basically the same features as the Standard Edition, with the exception of transactional replication. Additionally, Analysis Services and Full-Text Search are only available on certain operating systems with this edition. This version is most appropriate for users who need SQL Server data on their local machine while they are disconnected from the network. A common example would be mobile users—like members of a sales force who need their data while they are out in the field. This version limits the number of concurrent database activities that can be running at once. This simply means that this edition isn't designed to handle lots of users or database activities.

□ SQL Server 2000 Windows CE Edition—This version of SQL Server 2000 runs on mobile devices—Windows CE. This compact version of SQL Server 2000 allows relational databases to be stored and managed on Windows CE devices for later synchronization. Plus, it gives users the capability to manage a SQL Server database remotely over the Internet from their CE devices.

□ SQL Server 2000 Developer Edition—This version of SQL Server 2000 supports all the available features (just like the Enterprise Edition), except it prohibits deployment on production servers. This version is designed for developers, consultants, and solution providers to use while developing and testing their applications.

□ SQL Server 2000 Evaluation Edition—This version is a fully functional version of SQL Server 2000 Enterprise Edition, but it will stop working after 120 days. It is available as a free trial to give organizations a chance to try out SQL Server 2000 Enterprise Edition before purchasing it.

□ SQL Server 2000 Desktop Engine (also called MSDE)—This version is a free and redistributable version of the SQL Server database engine. This means that you can include it in your setup programs for applications that use SQL Server to store data. The Desktop Engine doesn't include any of the SQL Server 2000 graphical user interface tools. Thus, other products (such as Access or SQL Server 2000 APIs) must be used to manage data stored in this version of SQL Server.

SQL Server 2000 Desktop Engine (MSDE) is not the same version as the SQL Server 7 Desktop Edition.

The SQL Server 7 Desktop Edition became the Personal Edition in SQL Server 2000. The SQL Server

2000 Desktop Engine was called the Microsoft Data Engine, or MSDE, in SQL Server 7.

0 0

Post a comment