O'Reilly logo

Microsoft® SQL Server™ 2000 Programming by Example by Carlos Eduardo Rojas, Fernando G. Guerrero

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The Copy Database Wizard

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required