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:
- Open the Define as Replication Source window.
- Select a schema from the Schema drop down list.
- Select a table name from the Table name drop down list.
- If you want full refresh copying for the source table, select the
Data capture is full refresh only check box.
- 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.
- 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.
This check box is selected automatically when the Table will be used for update anywhere check box
is selected.
- If you want support for logical partition keys, select the Changed data for partitioned key columns captured as delete
and insert check box.
- If the source table might be used as an origin table for update anywhere
replication, select the Table will be used for update anywhere
replication check box.
- If you checked the Table will be used for update anywhere
replication check box, select a radio button to specify a level of
Conflict detection.
- 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.
- 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