What is "Object Transfer Manager"??

[malkyb]

Microsoft's Technical Bulletin at

http://support.microsoft.com/support/kb/articles/Q242/3/77.asp

,
entitled 'INF: How to Use Data Transformation Service(DTS)', refers to something called 'Object Transfer Manager', or 'Transfer Manager' which it suggests, provides features not available in DTS. Does anyone know what this is? I can find only one other reference on the web, and that is generic, and not to a specific product or feature of SQL Server 7.0.

 

[tlbroadbent]

The article refers to a generic Object Transfer Manager - one that would handle transfer of object properties between heterogeneous data sources. For example, DTS can handle creation of tables and movement of data when transferring from Access to SQL but it doesn't handle the indexes, keys, defaults, etc. So far as I know there is no generic product.

However, DTS will handle the transfer of these properties between SQL 7 and higher databases. SQL 7 BOL explains, "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." Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[malkyb]

Thanks for the clarification Terry