Friday, September 01, 2006

SQL 2005 Database Version Features Comparison

Seeing as how it is the Friday before Labor Day and me and about 4 other people are the only ones here, I thought I would keep this short and sweet today. Last time I was ranting about the lack of a certain feature in SQL server 2005 and I thought I should be fair and talk a little about the features it does provide. To that end, I came across an article at SQL Server Central that compared the major features of the versions so I thought I would copy that here so you can see them. The above link will take you to the full article. As always, please feel free to send or post questions or comments. Have a great weekend and use that extra day off to do something fun or creative. Start that project you have been meaning to start, or post that blog you have been meaning to write, or do that thing with your family you have been meaning to do. There will always be more work, but we don't get another vacation day until Thanksgiving. So use it well my friends and enjoy!

SQL Server 2005 Enterprise Edition – The edition of SQL Server for large enterprises that need higher availability and more advanced features in SQL Server and business intelligence. For example, there is no limit on processors or RAM in this edition. Available for an estimated retail price (ERP) of $24,999 ( U.S.) per processor or $13,499 ( U.S. ) per server (25 CALs). Microsoft will also continue to support Developer Edition, that let’s developers develop SQL Server solutions at a much reduced price. That edition has all the features of Enterprise Edition but is licensed for development purposes only.

SQL Server 2005 Standard Edition – This edition of SQL Server has a lot more value in this 2005. For example, you can now create a highly-available system in Standard Edition by using clustering, database mirroring and integrated 64 bit support. These features were only available in Enterprise Edition in SQL Server 2000 and caused many enterprises to purchase Enterprise Edition when Standard Edition was probably sufficient for them. Like Enterprise Edition in SQL Server 2005, it also offers unlimited RAM! So, you can scale it as high as your physical hardware and OS will allow. There is a cap of 4 processors though. Available for an ERP of $5,999 ( U.S.) per processor or $2,799 ( U.S. ) per server (10 CALs).

SQL Server 2000 and 2005 Workgroup Editions – This edition is meant for small and medium businesses that need a database server with no business intelligence or Reporting Services. Available for an ERP of $3,899 ( U.S.) per processor or $739 ( U.S. ) per server (five CALs), Workgroup Edition supports up to two processors, unlimited database size. In SQL Server 2000 Workgroup Edition, the limit is 2GB of RAM. In SQL Server 2005 Workgroup Edition, it raises to 3 GB.

SQL Server 2005 Express Edition – This edition is the equivalent of Desktop Edition (MSDE) in SQL Server 2000 but with a lot more enhancements. For example, MSDE never offered any time of management tool and that is included in 2005. Also included is the Import/Export Wizard and a series of other enhancements. This remains to be a free addition of SQL Server for small applications. It has a limit of 4 GB databases. Most importantly is that the query governor has been removed from this edition allowing for more people to query the instance at the same time.

The full comparison chart can be found here.

No comments: