SQL Server includes a new tool to copy databases between two servers: the Copy Database Wizard. The Copy Database Wizard is implemented as a custom DTS package with the following custom tasks:
Database Move/Copy Task—Using this task, you can select source and destination servers, as well as a database or databases to move or copy. Using this custom task, you specify the location for the database files in the destination server.
Logins Copy Tasks—Used to copy existing logins from the source to the destination server.
Master Stored Procedures Copy Task—Used to copy user-defined stored procedures from the master database in the source server to the master database in the destination server.
Jobs Copy Task—Used to copy jobs ...