Transfer Database Objects Tasks

Usually, you use the Copy SQL Server Objects task to copy database objects from one database to another. However, you can use Transfer Database Objects tasks to copy server-wide information not necessarily found in individual databases. These tasks cover situations not addressed by the Copy SQL Server Objects task.

Note The Transfer Database Objects tasks are custom tasks used by the Copy Database Wizard. For more information, see Using the Copy Database Wizard.

Transfer Database Task

Use this task to move or copy a Microsoft® SQL Server™ database from an instance of SQL Server version 7.0 or SQL Server 2000 to an instance of SQL Server 2000. When configuring this task, specify each database, indicate whether each database is to be moved or copied, and specify the location of the resulting data and log files.

Transfer Error Messages Task

Use this task to copy user-specified error messages, created by the sp_addmessage system stored procedure, from an instance of SQL Server 7.0 or SQL Server 2000 to an instance of SQL Server 2000. When configuring this task, specify the source and destination servers and the error messages to be transferred.

Transfer Logins Task

Use this task to copy logins from an instance of SQL Server 7.0 or SQL Server 2000 to an instance of SQL Server 2000. When configuring this task, specify the source and destination servers, the database to be moved or copied, and the logins to be transferred.

Transfer Jobs Task

Use this task to copy jobs from an instance of SQL Server 7.0 or SQL Server 2000 to an instance of SQL Server 2000. When configuring this task, specify the source and destination servers and the jobs to be copied.

Transfer Master Stored Procedures Task

Use this task to copy stored procedures from a master database on an instance of SQL Server 7.0 or SQL Server 2000 to the master database on an instance of SQL Server 2000. When configuring this task, specify the source and destination servers and the stored procedures to be copied.

Note If you unregister a Transfer Database Objects task and want to re-register the task, do the following: from the Task menu, click Register Custom Task, click the browse (...) button, and then open Cdwtasks.dll.