Roxanne25
asked on
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.