Converting a Member of an Incremental Group

The ability to convert incremental subscription members to a snapshot subscription preserves any customization work you may have done, such as column mappings and pre- and post-processing. The original incremental subscription is not changed or removed, so you should take steps to avoid target file conflicts - either apply a member qualifier to the Destination Table Name, delete the I/R subscription when you are done, or coordinate when you run the snapshot subscription or run the I/R group.

The procedure is similar to copying an incremental subscription member to another replication group; see Copying a Member of an Incremental Group.

  1. Pause the FROM I/R group with Pause Updates.

  2. In the Data Replication Manager, display the members of the incremental group containing subscriptions that you wish to copy.

  3. Select the members (subscriptions) that you wish to copy. Use the control or shift keys to select multiple members.

  4. Right click and select Copy Member from the drop down menu. If Copy Member is disabled, then you need to pause the group.

  5. Choose the "Convert to Snapshot" button.

  6. To avoid subscription or destination name conflicts, enter a member qualifier and apply to either Subscription, Destination Table Name, or both. You may also replace a previously-specified prefix or suffix by entering a value for the "Old Qualifier".

The destination group information is not used and should be ignored.

The new snapshot subscriptions will appear under the same Source as the original incremental subscriptions. If desired, you can then add the new subscriptions to a snapshot group.