[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


SQL Server 2000 vs. 2008

Posted on 2009-04-15
Medium Priority
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
  • 2
  • 2

Author Comment

ID: 24151181
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

chapmandew earned 2000 total points
ID: 24151237
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

ID: 24151630
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

chapmandew earned 2000 total points
ID: 24151661
YOu don't have to redo them...you can save them to the new server and run them as they are...they'll be int he legacy folder.

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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.
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.
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

834 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