Use the Objects page of the Transfer SQL Server Objects Task Editor dialog box to specify properties for copying one or more SQL Server objects from one instance of SQL Server to another. Tables, views, stored procedures, and user-defined functions are a few examples of SQL Server objects that you can copy. For more information about this task, see Transfer SQL Server Objects Task.
The user who creates the Transfer SQL Server Objects task must have sufficient permissions on the source server objects to select them for copying, and permission to access the destination server database where the objects will be transferred.
Select a SMO connection manager in the list, or click <New connection...> to create a new connection to the source server.
Select a database on the source server from which objects will be copied.
Select a SMO connection manager in the list, or click <New connection...> to create a new connection to the destination server.
Select a database on the destination server to which objects will be copied.
Select whether the selected objects will be dropped first on the destination server before copying.
Select whether extended properties will be included when objects are copied from the source to the destination server.
Select whether data will be included when objects are copied from the source to the destination server.
Specify how data will be copied to the destination server. This property has the options listed in the following table:
Data on the destination server will be overwritten.
Data copied from the source server will be appended to existing data on the destination server.
The ExistingData option is only available when CopyData is set to True.
Select whether the schema is copied during the Transfer SQL Server Objects task.
CopySchema is only available for SQL Server.
Select whether the transfer of objects should include the collation specified on the source server.
Select whether copying the selected objects will cascade to include other objects that depend on the objects selected for copying.
Select whether the task will copy all objects in the specified source database or only selected objects. Setting this option to False gives you the option to select the objects to transfer, and displays the dynamic options in the section, CopyAllObjects.
Expand ObjectsToCopy to specify which objects should be copied from the source database to the destination database.
ObjectsToCopy is only available when CopyAllObjects is set to False.
The options to copy the following types of objects are supported only on SQL Server:
XML schema collections
Specify whether database users should be included in the transfer.
Specify whether database roles should be included in the transfer.
Specify whether SQL Server logins should be included in the transfer.
Specify whether object-level permissions should be included in the transfer.
Specify whether indexes should be included in the transfer.
Specify whether triggers should be included in the transfer.
Specify whether full-text indexes should be included in the transfer.
Specify whether primary keys should be included in the transfer.
Specify whether foreign keys should be included in the transfer.
Specify whether the generated transfer scripts are in Unicode format.