PRB: DTS Does Not Copy Identity, Indexes, Primary Key or Other Constraints (220163)
The information in this article applies to:
- Microsoft SQL Server 7.0
- Microsoft SQL Server 2000 (all editions)
This article was previously published under Q220163 SYMPTOMS
When you run the Data Transformation Services (DTS) Wizard from SQL Enterprise Manager and copy tables from a SQL Server 6.5 source to a SQL Server 7.0 destination, DTS does not copy identity attributes, indexes, primary keys, or other constraints.
CAUSE
This is by design, as documented in SQL Server 7.0 Books Online:
Transferring Database Objects
When using heterogeneous data sources, the built-in facilities of DTS only move table definitions and data. To transfer other objects such as indexes, constraints, and views you must use methods such as specifying tasks that execute the SQL statements needed to create these objects on the destination data source. However, if both the source and destination are SQL Server 7.0 data sources, you can define a Transfer SQL Server Objects task to transfer indexes, views, logins, stored procedures, triggers, rules, defaults, constraints, and user-defined data types in addition to transferring the data.
WORKAROUND
Here are two ways to work around this behavior:
Modification Type: | Major | Last Reviewed: | 2/24/2004 |
---|
Keywords: | kbpending kbprb KB220163 kbAudDeveloper |
---|
|