Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am looking at upgrading our SQL Servers from 2005 Enterprise edition to SQL Server 2008 R2 Standard edition.

Obviously, the upgrade to 2008 R2 gives us more features even in Standard edition, but I am wondering what features will be lost by going from Enterprise down to Standard, if any.

I've tried searching around for this but there are only comparisons between editions on the same version (i.e. 2008 Standard vs Enterprise) not comparasions between different editions across different versions (i.e. 2005 Enterprise vs 2008 Standard).

Anyone got any advice or has any resource they can point me at?

thanks in advance.

share|improve this question

migrated from Dec 30 '11 at 15:16

This question came from our site for professional and enthusiast programmers.

Very few SQL language features are different between editions.

Some language constructs (CREATE PARTITION for example and related) are additional (as opposed to different) and won't work because these are Enterprise features.

However, for day to day code, nothing special, things are almost identical.

The only thing I can recall that is different is how indexed views are used

share|improve this answer
I think you can only do a 2 node cluster with Standard. You might also lose out on some of the higher end HA features. These things might not matter though. – Brandon Dec 30 '11 at 23:31

You can cross reference and compare the features for 2005 with the features in 2008 R2

As far as advice... if you are using features that are not available in SQL Server 2005 Standard, then you'll need to verify that those features are in SQL Server 2008 R2 Standard.

share|improve this answer

You'll be loosing things like online index rebuilds, partitioning, and some features like the ability to automatically use an indexed view when querying the base tables without an index hint. There's a few others in there as well.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.