dmmarktablecapturepoint - Mark a table capture point on a source table

Use this command to mark a table capture point on a source table and change the status of the table to Active. If you changed the table before executing this command, those changes will not be replicated.

Mark a table capture point on a source table 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 CDC Replication (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. 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 in the Map Tables wizard. If you want to override the position set by CDC Replication, then you can manually mark a table capture point in Management Console. 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.

Syntax

dmmarktablecapturepoint [-I <name>] -s <subscription ...>  
 -A|-t <<schema>.<table>...> [-L <locale>]

Parameters

[-I <name>]: Specifies the name of the CDC Replication instance. Alternatively, you can specify the TSINSTANCE environment variable in place of this value.
-s <subscription ...>: Specifies the subscription name.; To specify multiple subscriptions, list the subscriptions separated by a space.
-A: Specifies that CDC Replication overrides an existing position in the stream of changed data on all source tables in the subscription.
-t <schema>.<table> ...: Specifies the name of a source table in the subscription on which CDC Replication marks a table capture point. You must specify the table name in the format schema.table.; To specify multiple tables, list the tables separated by a space.
[-L <locale>]: The name of the locale used for the CDC Replication instance. The default is your machine's locale.

Result

This command returns a value of 0 if the command was successful and a non-zero value if the command fails.

Examples

dmmarktablecapturepoint
-I MYINSTANCE -s FINANCE -A

CDC Replication sets the status of all tables in the Finance subscription to Active.

dmmarktablecapturepoint
-I MYINSTANCE -s ACCOUNTING -t myschema.mytable

CDC Replication sets the status of the specified table in the Accounting subscription to Active.