Flagging a source table for a Standard Refresh

A Standard Refresh results in a complete copy of the data in a source table being sent to the target table. This operation truncates or deletes the contents of the target table and then inserts the new contents as sent by the source system.

About this task

Procedure

  1. Ensure that you have ended any active replication on the subscription.
  2. Click Configuration > Subscriptions.
  3. Select the subscription that contains the mapped source and target tables.
  4. Select the mapped source and target tables in the Table Mappings view.
  5. Right-click on the table and click Flag for Refresh ....
  6. Select Standard Refresh.
  7. If you only want to refresh a subset of rows under certain conditions, then enable the Refresh only a subset of rows check box. Enter an SQL WHERE clause in both the Source WHERE clause and Target WHERE clause list box. You must ensure that the subscription is set to a replication method of Mirroring. You set this when mapping tables in the Map Tables wizard.

    This feature is not available for CDC Replication Engine for Netezza® Technology, or CDC Replication Engine for FlexRep datastores.

  8. Click OK.