SQL Server 2000 vs. 2008

Posted on 2009-04-15
Last Modified: 2012-05-06
Hi, I have been tasked to do a write up for my company on the benefits from upgrading to a 2008 enviornment from a 2000.  I have been doing some research online and I am very familiar with the products but I'm having a hard time finding comparisons between 2000 and 2008.  I can see a lot for 2005 to 08 or 2000 to 2005, but just wondering if anybody could point me to a few good sites or can list off some of the key differences/enhancements.
Question by:Roxanne25

    Author Comment

    And sorry specifically I'd like to highlight the differences between stored procedures, T-SQL code, DTS and Triggers.

    We have a lot of .cmd files that we execute via msshell in DOS ... wondering if those will still work in 2008 or if there is a better way to do that.
    LVL 60

    Accepted Solution

    For the most part, the differences are the same between 2000 vs 2005...there are a few administration enhancements, other enhancements, etc.  But, the major differences are between 2000 and 2005.  

    To do your upgrade, you're better off installing 2008 on new machines, and then backuping and restoring your 2000 databases to your new 2008 instance.

    Author Comment

    Ok thanks, yea I was also thinking a fresh install and move over would be better.

    Would the old .cmd files still work and be runnable via the command shell?  

    Also, if I remember correctly DTS packages from 2000 are not portable into 2005/08?  I think when I migrated at a previous company we were able to import a few of them but most of them we had to redo.
    LVL 60

    Assisted Solution

    YOu don't have to redo can save them to the new server and run them as they are...they'll be int he legacy folder.

    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!

    Join & Write a Comment

    Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
    In this article I will describe the Detach & Attach 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.
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    728 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

    20 Experts available now in Live!

    Get 1:1 Help Now