What version to go for (updgrade) after SQL Server 2000???

I have developed one project very long back in .NETFramework 2.0 and SQL Server 2000 for one doctor in USA. He is still using thatsoftware but since than many rules gets changed in USA so he come back to mewith those changes and also told me that I want to use latest technology for myproject and database.
He might have searched internet for getting knowledge aboutthe latest version of .NET and SQL Server. Talking about SQL Server, he told methat the latest version of SQL Server is “Denali” and I want to use it in myproject. While talking about this, I made him understand that we should go forSQL Server 2008 R2 rather than “Denali” by giving some very strong and validreason and one of that strong reason is “Denali” is not in production, it is inCTP (Community Technology Preview).
But after this discussion, I felt to share some of mypersonal opinions on this blog.
After SQL Server 2000 version, you have three choices forupgrade.
1.)    SQLServer 2005
2.)    SQLServer 2008
3.)    SQLServer 2008 R2
I am excluding “SQL Server Denali” from this as it is stillCTP version, not good to choose it for production as of now though it has eyecatchy and flashy features which attract you.
Out of these three versions, I would, personally, like to gofor “SQL Server 2008 R2”. Let me tell you why I am thinking this.
SQL Server 2005 is not a good deal at this time, though it has upgradedengine and many new features as compared with SQL Server 2000, SQL Server 2005is now in “ExtendedSupport”. It means you will neither get any “No-Charge” support nor claimany warranty. Soon after release of “Denali”, Microsoft may end even “ExtendedSupport” for SQL Server 2005 (may be in 2014/2015).
While compare SQL Server 2008 with SQL Server 2008 R2, R2gives much more facility than SQL Server 2008, mainly multiserver management,greater security, self service BI and many more.
Apart from that, SQL Server 2008 was released in 2008 andSQL Server 2008 R2 is released in 2010 so you will get longer support in “SQLServer 2008 R2” then “SQL Server 2008”, means better reward of your money. 
Generally in any SQL Server, you get support for yourversion for minimum 10 years. Suppose SQL Server 2008 R2 releases in 2010, Microsoftwill definitely give you support for SQL Server 2008 R2 till 2020. For detailedunderstanding of support life cycle, refer Microsoft website from here.You have to go to “SUPPORT LIFECYCLE” tab in that link.
This is what I am thinking; this article is totally based onmy personal view. You have to decide the proper version by looking at your need;this article is just the guideline to make you aware with some of the factswhich may help you in your decision.
Reference: Ritesh Shah

Note: Microsoft Books online is a default reference of all articles butexamples and explanations prepared by Ritesh Shah, founder of
Ask me any SQL Server related question at my “ASK Profile

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: