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

Dear SQL Server experts,

Can you tell me the different between SQL-Server 2008 R2 and SQL-Server 2012 versions? I designed my product with version 2008 but when I tried to buy a licence, Microsoft said they won't sell it anymore, buy 2012 instead.

So I need proof that our system can run with 2012. I know it's backward compatible but I need official proof. Please help me.

share|improve this question
up vote 10 down vote accepted

A few things you'll want to watch out for:

For an official list (it doesn't include all of the above items, and there may be others that aren't coming to mind):

You may also want to check the discontinued features page:

And also run the Upgrade Advisor against your instance, this is exactly what it's for:

share|improve this answer
Aaron, your first link gets "Page Not Found". (2012-06-29) – Rob Garrison Jun 29 '12 at 22:07
@RobGarrison Yeah they deleted the original answer because it was cross-posted. – Aaron Bertrand Jun 29 '12 at 22:08
LOL, you left out licensing costs – brian Jun 30 '12 at 2:06
@brian the whole licensing thing is blown out of proportion. Most customers end up paying the same price unless they have CPUs with > 4 cores. – Aaron Bertrand Jun 30 '12 at 2:20

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.