Copying a subscription

Copying a subscription is a timesaving mechanism. If you have a subscription that contains table mappings that you do not want to recreate, then you can copy the subscription under a new name. You can also recreate an existing subscription with the same table mappings if you want to set up a replication scenario within in another environment.

1. Click Configuration > Subscriptions.
2. Right-click on a subscription and select Copy Subscription.
3. Enter a name for the subscription in the Name box.

   All subscriptions that come from the same source datastore must have a unique name and all subscriptions that go to the same target datastore must have a unique Source ID. The source ID is automatically generated based on truncating the subscription name to 8 characters. If you attempt to create a subscription with a duplicate Source ID, an error will result and the subscription will not be created. If this occurs, click Advanced Settings and give the subscription a unique Source ID.

4. Enter a description for the subscription in the Description box.
5. If you want to include the new subscription in a project, select a project from the Project list or click New Project to create a new project.

   If you do not select a project, Management Console places the new subscription into the Default Project.

6. Click Next.
7. Select the source datastore for the new subscription from the New Source Datastore list.
8. Select the databases and owners for your new source datastore under New Name.
9. Click Next.
10. If you want to specify advanced settings for the subscription, click Advanced Settings. Modify the following properties and click OK, then click OK again.

    On the General tab, the following properties can be set:

    Source ID

    Specify the source ID for the new subscription.

    TCP Host

    Specify the TCP host that your source datastore will use to recognize the target datastore when the computer where CDC Replication is installed has multiple network cards. This is useful if you want to specify a host that is different from the host that you specified in the Access Manager perspective. The default option is Auto-select, which will automatically select the network card that can communicate with the target datastore. The host that you specified in the Access Manager perspective also appears by default as well as any alias that you configured in the Datastore Properties dialog box.

    Firewall Port

    Specify a port number for the new subscription.

    Mark subscription as persistent

    Enable if you want to specify that the subscription is persistent. A subscription can only be restarted automatically if it is enabled for persistency. This feature is only enabled for subscriptions whose datastores support the functionality.

    Select the datastore to handle the transferable work

    Specify where transferable work will be performed, in order to minimize impact on the source or target datastore.

    Minimize network load

    Specify whether to minimize the network load where possible, even if it may result in increased replication latency. This option is only available when both the source and target datastores support the functionality.

    On the Propagation Control tab, the following properties can be set:

    Propagation Control

    Click Add and select the source ID for any subscription for which you want to prevent data from being replicated to the target.

    On the Communication Protocol tab, you can specify the communications protocol that will be used by the source datastore to communicate with the target datastore

    Do not replicate data received from any subscriptions

    Enable if you want to prevent replication from all subscriptions.

    TCP/IP

    Specifies that TCP/IP will be used exclusively as the communication protocol.

    JMS

    Specifies that either TCP/IP or JMS message queues will be used as the communication protocol.

11. Click Next.
12. Select the target datastore for the new subscription from the New Target Datastore list.
13. Select the databases and owners for the new target datastore under New Name.
14. Click Next.
15. If the existing subscription contains user exits, then specify their location for the new subscription under New Location and click Next.
16. If you built a derived column, an expression, or a row-filtering expression that uses the %SELECT column function, then confirm the list of displayed expressions and click Next.

    After copying the subscription, you may have to change these expressions manually.

17. Review the list of changes and click Finish.