Transforming Published Data
With snapshot and transactional replication comes the option of transforming data as it goes to the subscriber. Data can be mapped to different columns or datatypes, and it can be filtered using DTS packages.
Examples of how you can use data transformation include
Custom vertical and horizontal partitions of published data on a per subscriber basis.
Data transformations such as data type mappings (that is, datetime to char data type), column manipulations (that is, concatenating first name and last name columns), string manipulations, and functions.
When you create a publication, you have the option of using data transformations. After a DTS package is created, it can be used during the subscription process, attached ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition 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.
