Copying selected table mappings

Copying selected table mappings is similar to copying a subscription except that it only copies the mappings that you select to a new subscription. This is useful if you only want to copy a subset of the mappings in a subscription.

Procedure

  1. Click Configuration > Subscriptions.
  2. Select the subscription with the table mappings you want to copy.
  3. Right-click one or more table mappings in the Table Mapping view and select Copy... .
  4. 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.

  5. Enter a description for the subscription in the Description box.
  6. 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.

  7. Click Next.
  8. Select the source datastore for the new subscription from the New Source Datastore list.
  9. Select the databases and owners for your new source datastore under New Name.
  10. If you want to specify advanced settings, click Advanced Settings.
  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 and click Next.
  14. If the existing subscription contains user exits, then specify their location for the new subscription under New Location and click Next.
  15. 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.

  16. Review the list of changes and click Finish.