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.

1 Answer 1


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:


  • 1
    LOL, you left out licensing costs
    – brian
    Commented Jun 30, 2012 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. Commented Jun 30, 2012 at 2:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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