Copy Database Wizard (Select Database Objects)

Use this page to select the objects to include in the move or copy operation. To include an item in the move or copy operation, click the object name in the Available related objects box, and then click the >> button to move the object to the Selected related objects box. To exclude an item in the move or copy operation, click the object name in the Selected related objects box, and then click the << button to move the object to the Available related objects box.

By default all objects of each selected type are transferred. To choose individual objects of any type, click the ellipsis button next to any object type in the Selected related objects box. This opens a dialog box where you can select individual objects.

Note

This page is only available when the source and destination are different servers.

Options

• Logins (All logins at run time)
  Include logins in the move or copy operation. Selected by default.

• Stored procedures from master database
  Include stored procedures from the master database in the move or copy operation.

  Note

  Extended stored procedures and their associated DLLs are not eligible for automated copy in SQL Server 2005.

• SQL Server Agent jobs
  Include jobs from the msdb database in the move or copy operation.

• User-defined error messages
  Include user-defined error messages in the move or copy operation.

• Endpoints
  Include endpoints defined in the source database. SQL Server 2005 only.

• Full-text catalog
  Include full-text catalogs from the source database. SQL Server 2005 only.

• SSIS Package
  Include SSIS packages defined in the source database. SQL Server 2005 only.

• Description
  A description of the object.