In this first part of our series on this new product, lets take a look at the four different editions of SQL Server 2005 that Microsoft plans to release:
- SQL Server 2005 Express replaces the Microsoft Data Engine (MSDE) as the free version of SQL Server for application development and lightweight use. It remains free and retains the limitations of MSDE with respect to client connections and performance. Its a great tool for developing and testing applications and extremely small implementations, but thats about as far as you can run with it.
- SQL Server 2005 Workgroup is the new entrant in the product line. Its billed as a small business SQL Server and it offers an impressive array of functionality for a $3,899 price tag per processor. (Its also available under a 5-user license for $739). Workgroup edition maxes out at 2 CPUs with 3GB of RAM and allows for most of the functionality youd expect from a server-based relational database. It offers limited replication capabilities as well.
- The workhorse SQL Server 2005 Standard Edition remains the staple of the product line for serious database applications. It can handle up to 4 CPUs with an unlimited amount of RAM. Standard Edition 2005 introduces database mirroring and integration services. Its priced at $5,999 for a processor or $2,799 for 5 users.
- The big kid on the block is SQL Server 2005 Enterprise Edition. With the release of 2005, Enterprise Edition allows unlimited scalability and partitioning. Its truly an enterprise-class database and its hefty price tag ($24,999 per processor or $13,499 for 5 users) reflects its value.