O'Reilly logo

Guru's Guide to SQL Server Architecture and Internals, The by Ken Henderson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required