Take the 2-minute tour ×
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. It's 100% free, no registration required.

Dear SQL Server expert,

Can you tell be the different between SQL server 2008 R2 and SQL server 2012. I design my product with SQL 2008, but when I buy a lincence, Microsoft said they wont sell it anymore, buy 2012 instead. So I need a proof that our system can run with 2012. i know its backward compatible but I need official proof. Please help me

share|improve this question
add comment

1 Answer

up vote 8 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):

http://technet.microsoft.com/en-us/library/ms143179(v=SQL.110).aspx

You may also want to check the discontinued features page:

http://technet.microsoft.com/en-us/library/ms144262

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

http://technet.microsoft.com/en-us/library/ms144256.aspx

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
1  
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
add comment

Your Answer

 
discard

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.