Export (0) Print
Expand All
Expand Minimize

Transfer SQL Server Objects Task Editor (Objects Page)

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.

NoteNote

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.

SourceConnection

Select a SMO connection manager in the list, or click <New connection...> to create a new connection to the source server.

SourceDatabase

Select a database on the source server from which objects will be copied.

DestinationConnection

Select a SMO connection manager in the list, or click <New connection...> to create a new connection to the destination server.

DestinationDatabase

Select a database on the destination server to which objects will be copied.

DropObjectsFirst

Select whether the selected objects will be dropped first on the destination server before copying.

IncludeExtendedProperties

Select whether extended properties will be included when objects are copied from the source to the destination server.

CopyData

Select whether data will be included when objects are copied from the source to the destination server.

ExistingData

Specify how data will be copied to the destination server. This property has the options listed in the following table:

Value

Description

Replace

Data on the destination server will be overwritten.

Append

Data copied from the source server will be appended to existing data on the destination server.

NoteNote

The ExistingData option is only available when CopyData is set to True.

CopySchema

Select whether the schema is copied during the Transfer SQL Server Objects task.

NoteNote

CopySchema is only available for SQL Server.

UseCollation

Select whether the transfer of objects should include the collation specified on the source server.

IncludeDependentObjects

Select whether copying the selected objects will cascade to include other objects that depend on the objects selected for copying.

CopyAllObjects

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.

ObjectsToCopy

Expand ObjectsToCopy to specify which objects should be copied from the source database to the destination database.

NoteNote

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:

Assemblies

Partition functions

Partition schemes

Schemas

User-defined aggregates

User-defined types

XML schema collections

CopyDatabaseUsers

Specify whether database users should be included in the transfer.

CopyDatabaseRoles

Specify whether database roles should be included in the transfer.

CopySqlServerLogins

Specify whether SQL Server logins should be included in the transfer.

CopyObjectLevelPermissions

Specify whether object-level permissions should be included in the transfer.

CopyIndexes

Specify whether indexes should be included in the transfer.

CopyTriggers

Specify whether triggers should be included in the transfer.

CopyFullTextIndexes

Specify whether full-text indexes should be included in the transfer.

CopyPrimaryKeys

Specify whether primary keys should be included in the transfer.

CopyForeignKeys

Specify whether foreign keys should be included in the transfer.

GenerateScriptsInUnicode

Specify whether the generated transfer scripts are in Unicode format.

CopyAllObjects = False

CopyAllTables

Select whether the task will copy all tables in the specified source database or only the selected tables.

TablesList

Click to open the Select Tables dialog box.

CopyAllViews

Select whether the task will copy all views in the specified source database or only the selected views.

ViewsList

Click to open the Select Views dialog box.

CopyAllStoredProcedures

Select whether the task will copy all user-defined stored procedures in the specified source database or only the selected procedures.

StoredProceduresList

Click to open the Select Stored Procedures dialog box.

CopyAllUserDefinedFunctions

Select whether the task will copy all user-defined functions in the specified source database or only the selected UDFs.

UserDefinedFunctionsList

Click to open the Select User Defined Functions dialog box.

CopyAllDefaults

Select whether the task will copy all defaults in the specified source database or only the selected defaults.

DefaultsList

Click to open the Select Defaults dialog box.

CopyAllUserDefinedDataTypes

Select whether the task will copy all user-defined data types in the specified source database or only the selected user-defined data types.

UserDefinedDataTypesList

Click to open the Select User-Defined Data Types dialog box.

CopyAllPartitionFunctions

Select whether the task will copy all user-defined partition functions in the specified source database or only the selected partition functions. Supported only on SQL Server.

PartitionFunctionsList

Click to open the Select Partition Functions dialog box.

CopyAllPartitionSchemes

Select whether the task will copy all partition schemes in the specified source database or only the selected partition schemes. Supported only on SQL Server.

PartitionSchemesList

Click to open the Select Partition Schemes dialog box.

CopyAllSchemas

Select whether the task will copy all schemas in the specified source database or only the selected schemas. Supported only on SQL Server.

SchemasList

Click to open the Select Schemas dialog box.

CopyAllSqlAssemblies

Select whether the task will copy all SQL assemblies in the specified source database or only the selected SQL assemblies. Supported only on SQL Server.

SqlAssembliesList

Click to open the Select SQL Assemblies dialog box.

CopyAllUserDefinedAggregates

Select whether the task will copy all user-defined aggregates in the specified source database or only the selected user-defined aggregates. Supported only on SQL Server.

UserDefinedAggregatesList

Click to open the Select User-Defined Aggregates dialog box.

CopyAllUserDefinedTypes

Select whether the task will copy all user-defined types in the specified source database or only the selected UDTs. Supported only on SQL Server.

UserDefinedTypes

Click to open the Select User-Defined Types dialog box.

CopyAllXmlSchemaCollections

Select whether the task will copy all XML Schema collections in the specified source database or only the selected XML schema collections. Supported only on SQL Server.

XmlSchemaCollectionsList

Click to open the Select XML Schema Collections dialog box.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft