Creating a Transformable Subscription Using Replication Wizards

Creating a Transformable Subscription Using Replication Wizards

Creating a transformable subscription using the replication wizards requires the following steps:

1. Create a new snapshot publication or transactional publication and enable the publication for transformable subscriptions using the Create Publication Wizard.
   
   
2. Build the replication DTS package (define the columns and rows in the partition, and map the transformations) using the Transform Published Data Wizard (available by right-clicking the publication that allows data transformations and selecting Define Transformation of Published Data).
   
   
3. Create a subscription that incorporates an existing replication DTS package to transform published data, using either the Push Subscription Wizard or the Pull Subscription Wizard (the DTS package must exist at the time a subscription is created). When creating a transformable subscription, you select from the existing DTS packages marked for replication.

After the replication DTS package is created, advanced users can edit the DTS package in DTS Designer to customize it for an individual Subscriber.

Note  You must enable a subscription to use a DTS package when you create the publication; you cannot modify an existing publication to use DTS packages.

To create a transformable subscription