SQL Server 2005 vs. 2008

Posted on 2009-02-12
Last Modified: 2012-05-06
I will be upgrading from SQL Server 2000 within the next couple of months.  I have been debating on which version to go with either 2005 or 2008?  If I go from 2000 to 2008 will there be more problems then if I just went to 2005?  Any suggestions welcome.
Question by:N R
    LVL 31

    Accepted Solution

    Personally I would mojust move to 2008. if you move to 2005 when you decide to move to 2008 you will be wondering should you do 2008 or the next version...

    a lot of people will wait to upgrade  any release until SP1 is released..

    in the end the decision is yours... but i would plan to move to 2008 and miss 2005
    LVL 8

    Assisted Solution

    You can just migrate to sql 2008. Either 2000 or 2005 you might be facing problems migrating SSIS Packages and SSAS cubes, coz it is totally a different architecture.
         You may want to read the technical document for further information on migration
    LVL 25

    Assisted Solution

    SQL 2005 is pretty stable at this point with SP3 just having been released in December 2008.. But if you opt for this, then a future upgrade to SQL 2008 will involve purchasing it unless you go for software assurance package which will be pretty expensive.

    SQL 2008 is pretty new, but that shouldn't necessarily be an issue as such.. Its really a judgement call on whether to take the plunge or not..

    The upgrade would be more or less the same in both I guess..

    LVL 57

    Assisted Solution

    by:Raja Jegan R
    I suggest you to go for SQL Server 2008 because it has lot more features and functionality in it.
    LVL 22

    Assisted Solution

    Migrating 2000 -> 2008 shouldn't be any more work than migrating 2000 -> 2005. From the point of view of backwards compatibility and breaking changes the big changes all apply to both. For example: SSIS replaces DTS; new SSAS cube model; BIDS; schema instead of owner; deprecated T-SQL features. 2008 lacks Notification Services, which is now discontinued.

    2008 isn't as big a leap in functionality as 2005 was but there are plenty of good reasons to use it:

    Upgrade Advisor:

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Via a live example, show how to shrink a transaction log file down to a reasonable size.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now