Create Publication Wizard, Welcome
The Welcome page of the Create Publication Wizard includes a description of the Create Publication Wizard and an option to select advanced options during the wizard.
If you enable Show advanced options in this wizard and you create a snapshot or transactional publication, you will be able to enable the publication for:
- Updatable subscription options for immediate updating and/or queued updating.
- Transforming data as it is published using Data Transformation Services (DTS).
When creating a merge publication, you will see all the options available whether the Show advanced options in the wizard check box is selected or not.
Updatable Subscriptions
Typically, replicated data is read-only. However, in Microsoft® SQL Server™ 2000, you have the ability to modify replicated data at the Subscriber by using updatable subscriptions with snapshot replication or transactional replication or by using merge replication. If you need to modify data at the Subscriber using snapshot replication or transactional replication, you can choose immediate updating, queued updating, or immediate updating with queued updating as a failover.
Transforming Published Data
Transformable subscriptions (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.