• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 413
  • Last Modified:

SQL Server 2000 vs. 2008

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.
0
Roxanne25
Asked:
Roxanne25
  • 2
  • 2
2 Solutions
 
Roxanne25Author Commented:
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.
0
 
chapmandewCommented:
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.
0
 
Roxanne25Author Commented:
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.
0
 
chapmandewCommented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now