Searching subscriptions for tables that are included in replication

In order to make tables available for replication, you must create a subscription and associate a source and target datastore. These datastores contain the tables you want to use in replication. You may have more than one subscription using the same table in replication. When you want to make the table unavailable from replication, it becomes important to search for the table and identify which subscriptions are using it replication activities.

Procedure

  1. Click Configuration > Datastores.
  2. Select a datastore.
  3. Right-click the datastore and select Replication Tables.
  4. Expand the Available Tables tree to display the tables.
  5. Select a table and click Properties to open the Table Properties dialog box.
  6. Click the Subscriptions tab.
  7. Click Search on the Subscriptions tab. If you do not want a case-sensitive search, clear the Match case box.
  8. In the search results, you can identify the subscription from the following:
    Subscription
    The name of the subscription that uses the selected table.
    Used As
    Identifies whether the table is used as source or target.
    Replication Method
    The replication method for the selected table.
    Table Status
    Identifies if the selected table has been refreshed, mirrored, or parked.