MSSQLTips

Many companies are still using SQL Server 2000.  At some point they need to upgrade.  Should they go to SQL Server 2005 or SQL Server 2008? 

What do you think and why?

I still have plenty of customers that are running SQL 2000. As of right now it is still kind of a toss up whether to go with SQL 2005 or SQL 2008.  There is a lot more information about SQL 2005, so generally it is a safer bet. As time continues to move on and the longer it takes I would probably steer them towards 2008.  SQL 2008 SP1 is now out, so this is one of those things people wait for before taking the leap to the next release level.  I guess it also really depends on the new feature set as well.  SQL 2008 provides plenty of new tools, so if there is a real advantage to using these tools this is another good reason to skip over 2005 and go right to 2008. 

hi,

sql server basically communicating information in one location .sql server depends upon the 2000 or 2005 or 2008 . And In the business world, everything is about being "better, faster and cheaper" than the competition -- and SQL Server 2005 offers many new features to save energy, time and money. From programming to administrative capabilities, this version of SQL Server tops all others and it enhances many existing SQL Server 2000 features..

 Due to plenty of new features, upgrade to SQL Server 2005 from SQL Server 2000 is a very good choice. In case of SQL Server 2008 it provides noteworthy enhancements mainly for BI and enterprise architechture.If you are not holding BI implementation like SSRS, SSAS and also you do not have a number of SQL Servers connected in various domains configured in your organisational structure then hardly you will feel any shortcomings in SQL Server 2005. 

I have upgraded to SQL Server 2005 and found it very satisfactory. Later i may look for SQL Server 2008 when i have to implement SSRS.