SQL Server Performance Forum – Threads Archive

Migration from SQL Server 2000 to 2005

Hello All, I am about investigation on migration from sql server 2000 to 2005.
Anyone knows some good articles or advices on this (side by side installation, DTS tranformation, ect.) Thank you all,
Jilia

---

http://support.microsoft.com/kb/910233
http://msdn2.microsoft.com/en-us/library/ms143706.aspx
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1216481,00.html for data, best option is backup and restore. After restoring do remember to rebuild all the indexes —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

---

You can take help of Upgrade advisor in this case that gives you realtime upgrade information in addition what referred above. Satya SKJ
Microsoft SQL Server MVP
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.

---

Also once you have upgraded from SQL 2000 to SQL 2005, you can’t revert back again to SQL 2000. Then you have to probably use DTS packages or import/export tools to move or revert back to 2000.

---

http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=19047
Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

---

]]>