If you specify for processing to occur for an incremental subscription, the source and/or target data is processed only for the baseline replication.The Processing properties for a subscription are SQL statements that automatically alter data in the source or destination databases, either immediately before or immediately after replication. Use the fields in the Source Processing frame to modify source data. Use the fields in the Destination Processing frame to modify destination data.
|
Source Processing |
Destination Processing |
|
Type one or more SQL statements in the source BEFORE edit field to alter the source table data just before each replication associated with the current subscription. |
Type one or more SQL statements in the destination BEFORE edit field to alter the destination table data just before each replication associated with the current subscription. |
|
Type one or more SQL statements in the source AFTER edit field to alter the source table data just after each replication associated with the current subscription. |
Type one or more SQL statements in the destination AFTER edit field to alter the destination table data just after each replication associated with the current subscription. |
Follow these guidelines when you enter the SQL statements in each processing frame:
To enter multiple SQL statements, type a semicolon (;) after each statement.
Use fully qualified table names. If you enter unqualified table names, the Data Replicator attempts to use the default database and owner.
Press ENTER within any of the edit fields to type on a new line.
You cannot specify SQL processing statements when you create multiple subscriptions at one time, although you can later edit individual subscriptions to add SQL processing statements.
If you specify for processing to occur for an incremental subscription, the source and/or target data is processed only for the baseline replication.