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.