Defining a custom replication source

Replication overview

Use the Define as Replication Source window to define tables as sources for replication.

If the window was invoked from the Create menu option, all fields are empty.

Fields and controls

Authorities and privileges



To define a custom replication source:

  1. Open the Define as Replication Source window.
  2. Select a schema from the Schema drop down list.
  3. Select a table name from the Table name drop down list.
  4. If you want full refresh copying for the source table, select the Data capture is full refresh only check box.
  5. If you want to make a column unavailable for replication, clear the Define as source check box for that column. When cleared, the column name becomes unavailable as a source column during subscription and cannot be replicated.
  6. If you do not want to capture the before image of a column, clear the Capture before image check box for that column. The after image is always replicated.

    Recommendation: Make all columns available as source columns for replication. You can select which columns to replicate to specific target tables when you include the table in a subscription. By defining your column subset in the subscription rather than in the replication source, you will not have to redefine your replication source if your subscription requirements change.

  7. If you want support for logical partitioning keys, select the Changed data for partitioned key columns captured as delete and insert check box.
  8. If the source table might be used as an origin table for update anywhere replication, select the Table will be used for update anywhere check box.
  9. If you checked the Table will be used for update anywhere check box, select a radio button to specify a level of Conflict detection.
  10. Click on OK to define a custom replication source. The Run Now or Save SQL window opens. You can choose to run your SQL request now or run it later.
  11. Refresh and verify your object.

    After verifying your object, remember to start or reinitialize the Capture program from your command line processor so that it will recognize the new replication source custom definition. See the Replication Guide and Reference for more information.



Related information