Post reply

Upgrade from 2000 to 2005 or to 2008

  • March 2, 2009 at 1:12 am

    #77265

    Our company still works with SQL server 2000. I'm now investigating wether it is better to upgrade to 2005 or to 2008 and skip one version.

    It would be nice to hear some input from the experts on this forum.

    Thanks in advance.

    Vera

  • March 2, 2009 at 1:38 am

    #951698

    Hi Vera,

    It is better to upgrade to Sql Server 2005 rather than Sql Server 2008.

    Beacuse Sql Server 2008 is very new and if any issues happen with Sql 2008 then very less help is available.

    Rather Sql 2005 is lil older now and you can find a lot of fixes and information regarding it on Microsoft site.Also Sql 2005 is having lot of new features so you can use it better than Sql 2000.

    Thanks

    S

  • March 2, 2009 at 7:40 am

    #951865

    Vera, I asked this question a couple of months ago and got very few replies! Having considered it and trawled various resources I have come to the conclusion that I would like to go straight to SQL 2008, but it depends on license costs and whether your apps are compatible with SQL 2008.

    So check your licence agreement with microsoft to see if there is any difference in charge, and check all your apps are compatible, this is particularly relevant if you use 3rd party apps.

    I believe SQL2008 is mature enough now, especially as it was only an evolution of 2005 rather than a major re-write, and SP1 is even out in CTP version.

    SQL 2005 is out of mainstream support in 2011, so if you upgrade to it you could have do another upgrade in only a couple of years, if you go straight to 2008 you have a minimum of 5 years and a maximum of 10 before you need think about another upgrade.

    Apart from an increased risk of code incompatibilities a SQL2008 upgrade is no more complex than a 2005 upgrade.

    Also in 2008 it seems you can back out service packs, about time!

    ---------------------------------------------------------------------

  • March 3, 2009 at 3:23 am

    #952292

    I would recommend going to 64-bit SQL Server 2008 running on Windows 2008. This will give you a platform that will remain current technology for a few years to come.

    The pain you will have in upgrading from SQL Server 2000 will be much the same if you go to SQL 2005 or SQL 2008. At present there is good support for both products available in newsgroups, but in maybe 2 years time a lot more people will be able to help with SQL 2008 than SQL 2005.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

  • March 3, 2009 at 9:01 am

    #952472

    I definitely tend to agree with Ed and George on this one. I would personally prefer to stay as current with the technology as humanly possible when given the chance to upgrade and deal with whatever struggles may arise from that. Obviously since it is not as mature of a product, there could be issues but there will always be issues when you upgrade and you can bet that whatever issues arise in 2008 are more likely to get attention than those that could still arise in 2005.

    So I say go with the latest version for more long term benefit, even though there could be some pain in the short term.

  • March 3, 2009 at 12:19 pm

    #952654

    Thank you all for your replies, I'll take them in consideration.

    Vera

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply