Marking a table capture point on a source table before mirroring

CDC Replication mirrors changes to the target table from the current position in the stream of changed data. This position is set by CDC Replication when you select Mirror (Change Data Capture) after mapping your tables. If you want to override the position set by CDC Replication, then you can manually mark a table capture point in Management Console.

About this task

When you decide to start mirroring on the subscription, CDC Replication identifies the position you have set as the point in time from which to capture and replicate database changes to the target.
Attention: Only use this procedure when you want to override an existing position in the stream of changed data. This is possible when you have already synchronized (refreshed) your source and target tables using an application other than Management Console (for example, using the import or export capabilities of your database platform) and you know the point in time your source and target are synchronized with each other.

Procedure

  1. Ensure that your database platform is in idle mode to avoid losing synchronization between your source and target tables.
  2. Ensure that you have ended any active replication on the subscription that contains the source table.
  3. Click Configuration > Subscriptions.
  4. Select the subscription that contains the mapped source and target tables.
  5. Select the mapped source tables in the Table Mappings view.

    You can mark a table capture point on more than one mapped source table at a time.

  6. Right-click and select Mark Table Capture Point For Mirroring.