Using DTS to Transform Replication Subscriptions

We'll discuss SQL Server's replication facilities in more detail in Chapters 21 through 23. For now, let's explore how you can use a DTS package to transform published data as it is provided to subscribers. You're probably familiar with the basic concept of a replication publisher—a server or machine that provides data to subscribers, the data consumers in a replication scenario. In addition to being able to use T-SQL to manipulate data as it's being published to subscribers, you can also create DTS packages that perform sophisticated transformations of the data en route. The package used to transform a subscription can reside at the distributor or at individual subscribers and can be used to partition ...

Get Guru's Guide to SQL Server Architecture and Internals, The now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.