oxburger
asked on
MS SQL 2000 vs SQL 2005
Could someone please give me some real world differences between MS SQL 2000 compared to MS SQL 2005?
I am considering upgrading to SQL 2005, but need to justify the cost.
Notes: I am a noob with SQL, as we currently run MS SQL 200 for three of our critical business applications on SBS 2003.
Thank you!
I am considering upgrading to SQL 2005, but need to justify the cost.
Notes: I am a noob with SQL, as we currently run MS SQL 200 for three of our critical business applications on SBS 2003.
Thank you!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Agree with the other opinions. There is no case at all for upgrading to 2005 unless you are forced to. Upgrade to 2008. The advantages over a decade old product that is no longer in mainstream support are almost too many to list. Check out microsoft.com.
Do bear in mind that the upgrade will entain a certain amount of work testing and possibly fixing certain things. There are some breaking changes to deal with.
Do bear in mind that the upgrade will entain a certain amount of work testing and possibly fixing certain things. There are some breaking changes to deal with.
You should consider upgrading to SQL 2008.