Copy SQL Server Objects Task (Copy Tab)

DTS Designer

DTS Designer Help

Copy SQL Server Objects Task (Copy Tab)

Use this tab to specify which objects to transfer from one Microsoft® SQL Server™ database to another. You can transfer only from one instance of SQL Server version 7.0 to another, from an instance of SQL Server 7.0 to an instance of SQL Server 2000, and from one instance of SQL Server 2000 to another.

Create destination objects

Create destination objects for all objects to be transferred (tables, views, stored procedures, defaults, rules, constraints, user-defined data types, logins, users, roles, and indexes). Specify the following copy options:

Drop destination objects first
Drop all corresponding destination objects before creating new ones.
Include all dependent objects
Include all dependent objects, such as the tables supporting a view, in the transfer of data.

Copy data

Enable the copying of SQL Server data from source to destination. Specify the following copy options:

Replace existing data
Overwrite existing data in the destination objects with the new data from the specified source.
Append data
Retain existing data in the destination object, and append new data from the specified source.

Use Collation

Enable the copying of data between different collations. For more information on using different collations with Data Transformation Services (DTS), see Data Conversion and Transformation Considerations.

Copy all objects

Transfer all objects associated with the specified data source.

Select objects

Display the Select Objects dialog box, where you can select or remove objects from the transfer process. Clear the Transfer all objects check box to enable this option.

Use default options

Set the advanced transfer options to their defaults.

Options

Display the Advanced Copy Options dialog box, where you can select or remove the specific objects to be transferred. Clear the Use default options check box to enable this option.

Script file directory

Specify the directory to which the script file and log files are written. The script file directory must exist on the computer on which the task runs.

See Also

Copy SQL Server Objects Task

TransferObjectsTask2 Object