Transform Published Data
Transforming published data (available with snapshot replication or transactional replication) leverages the data movement, transformation mapping, and filtering capabilities of Data Transformation Services (DTS). Using transformable subscriptions in your replication topology allows you to customize and send published data based on the requirements of individual Subscribers.
Examples of how you can use transformable subscriptions include:
- Creating column and horizontal partitions of published data on a per-Subscriber basis (custom data partitions).
- Creating data transformations such as data type mappings (for example, integer to real data type), column manipulations (for example, concatenating first name and last name columns), string manipulations, and use of functions.
The following options are available on the Transform Published Data page of the Create Publication Wizard.
Options
Yes, transform the data
Enables the transformation of published data. Transforming published data allows you to attach a DTS package to a subscription so that data is transformed as it is published.
No, all Subscribers receive data directly
Disables the transformation of published data.
After the transformation of published data is enabled, you can build a replication DTS package using the Transform Published Data Wizard. You will need to attach the DTS package as part of the subscription process. Transforming published data is supported for Microsoft® SQL Server™ 2000 and OLE DB Subscribers (ODBC Subscribers are not supported).
Note You cannot enable or disable the transformation of published data after the publication is created by modifying Publication Properties.