Using the Copy Database Wizard
The Copy Database Wizard allows you to copy or move databases between servers. You can move and copy databases between different instances of Microsoft® SQL Server™ 2000, and you can upgrade databases from SQL Server version 7.0 to SQL Server 2000. For more information, see Database Upgrade from SQL Server 7.0 (Copy Database Wizard).
To upgrade databases online using the Copy Database Wizard