This article explains how to move data out of SQL 2000 Server and into SQL Server 2005. This hands-on tutorial shows a step-by-step procedure for moving to SQL 2005, the new database from Microsoft released in November of 2005. Introduction
There are times when you want to move, to upgrade your living quarters, for example. This analogy is not too bad; you move because you are cramped for space, you don't have the latest fixtures, you take too long to shower because water is trickling and it is not hot. When administrators look at their servers and find that their file system has become cramped, they want to move to another file system, or another machine with more resources.
The article continues at http://www.aspfree.com/c/a/MS-SQL-Server/Moving-Data-from-SQL-Server-2000-to-SQL-Server-2005/