DTS Object Transfer tasks provide a powerful mechanism to transfer complete database objects and data from one Microsoft® SQL Server™ version 7.0 database to another. DTS Object Transfer tasks transfer tables, views, stored procedures, defaults, rules, user-defined data types, logins, users, roles, indexes, and constraints. All of the objects in a database can be transferred, or only a subset selected by the person who defines the task. If only selected objects are transferred, the task can specify that all dependent objects also be transferred.
When transferring tables, DTS Object Transfer tasks can transfer only the table definition, or it can also transfer the data. When a table definition is transferred, DTS can also transfer any user-defined data types, indexes, constraints, triggers or defaults associated with the table.
DTS Object Transfer tasks use the SQL-DMO ScriptTransfer and Transfer methods to connect to the source and destination using ODBC instead of OLE DB. Object transfer functionality is available only on clients that have installed SQL-DMO.