SQL Server Performance Forum – Threads Archive

Comparison: SQL 2000 vs. SQL 2005

Hi,
my company currently running SQL server 2000 and we wanted to upgrade to SQL Serevr 2005
but my manager asked me to get report what are the difference. is there any web site where I can get SQL server 2000 V/S SQL Server 2005 comparison list.. thanks
raj

Yes, go to Microsoft Web and you will find all comparision.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell Nunca esperes el reconocimiento de tus hijos, eso ocurrirÃ¡ luego de tu muerte
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Few article on this http://www.devx.com/dbzone/Article/21539
http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1137301,00.html —————————————-
http://spaces.msn.com/members/dineshasanka

It will be also a good chance for you to download and install SQL 2005 evaluation edition from MS site and test with some resource intensive database on your test platform, that can give you more indepth information about what your manager is wanted. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Hi:
I am sure the comparision list between MS SQL Server 2000 and 2005 is quite long because of new features added into latest version.. Check below link for New feature intrduced in SQL 2005
————————————————-
http://msdn2.microsoft.com/en-us/library/ms170363.aspx For SQL 2000
————————————————-
http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part1/c0261.mspx
Ok.. once you are familiar with new changes..its time to find which changes can affect your databases if moving on sql2005.. Microsoft SQL Server 2005 Upgrade Advisor
————————————————-
–It is a tool you can use to prepare for upgrades to SQL Server 2005. Upgrade Advisor analyzes installed SQL Server 2000 or SQL Server 7.0 components, and then generates a report that identifies issues that you must or should address to before or after upgrading to SQL Server 2005.
http://msdn2.microsoft.com/en-us/library/ms144256.aspx
Upgrading to SQL Server 2005
————————————————-
http://msdn2.microsoft.com/en-us/library/ms144245.aspx
Article on "Upgrading to SQL Server 2005"
————————————————-
http://www.informit.com/articles/article.asp?p=421049&seqNum=4
Deepak Kumar –This posting is provided â€œAS ISâ€ with NO rights for the sake of knowledge sharing.

my suggestion is get SQL2005 eval on a reasonable machine (data on multiple disks), best if you can have SQL 2000 on a second machine of approximately the same characteristic,
then run you big reporting queries, and use that as a comparison instead of trying duplicate your full workload

]]>