September 27, 2012 at 10:53 am
If a database application functions flawlessly on SQL Server 2008, close to 100 percent is the likelyhood that it will also function flawlessly on SQL Server 2008 R2?
Given that when vendor says "not supported" that can mean anything from "it won't work" to "we're not spending the money for comprehensive testing, so we make no promises," is there anything different in 2008 R2 that would potentially break something that worked in 2008?
September 27, 2012 at 12:05 pm
Pretty much. There are maybe 3 smallish things that changed in the DB engine between 2008 and 2008 R2 and some bug fixes. Most of the R2 stuff was BI-related
Test it first, of course, but there's very little different between the two versions
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 27, 2012 at 12:06 pm
From this article on MSDN, there were no features discontinued specifically in R2 (i.e anything more than what was on in 2008).
http://msdn.microsoft.com/en-us/library/ms144262(v=sql.105).aspx
So what worked in 2008 should still work in 2008R2 (excluding possibly some differences in performance, since changes to the DBEngine happen during every release).
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
September 27, 2012 at 12:18 pm
dan-572483 (9/27/2012)
If a database application functions flawlessly on SQL Server 2008, close to 100 percent is the likelyhood that it will also function flawlessly on SQL Server 2008 R2?Given that when vendor says "not supported" that can mean anything from "it won't work" to "we're not spending the money for comprehensive testing, so we make no promises," is there anything different in 2008 R2 that would potentially break something that worked in 2008?
In theory, something that works on 2008 will work on 2008R2. Obviously you want to test any new platform you're using with your production applications, but I'd be very surprised if it doesn't work exactly the same in R2. Most of the changes are added functionality, mainly in the area of BI.
Most likely, "not supported" in this case means "we haven't tested it".
However, even if that is the case, before you proceed there are two additional questions you need to get the answers to... First, what level of support is the vendor willing to provide should you decide to move forward on 2008R2? Are they going to deny you support, or provide you with less support than they would otherwise? Second, how dependent are you on the vendor for support? Are they your primary source for support, or just there for emergencies? Can you get by without them?
If this is a production system, you want to hear from the vendor why they aren't supporting 2008R2.... what issues, if any exist. You also want to know exactly what their policy is for customers who use platforms that aren't officially supported.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply