dmmarkexternalunloadend - End table data unload

Use this command when you want to perform a refresh outside of CDC Replication while the tables are still active. dmmarkexternalunloadend marks the ending point of the data unload for the external tool that is used to load the data to the target replication engine.

Syntax

dmmarkexternalunloadend [-I <name>] [-L <locale>] 
-s <subscription ...> [-t <table>]

Parameters

[-I <name>]: Specifies the name of the CDC Replication instance. Alternatively, you can specify the TSINSTANCE environment variable in place of this value.
[-L <locale>]: The name of the locale used for the CDC Replication instance. The default is your machine's locale.
-s <subscription ...>: Specifies that CDC Replication sends source metadata changes for the indicated subscriptions to the target.
[-t <table>]: Specifies the name of a source table in the subscription on which CDC Replication marks a table capture point. The tables must be named in the format <schema>.<table>.; To mark the table capture point on all the source tables in the specified subscription, omit this parameter.

Result

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

Examples

dmmarkexternalunloadend -I MYINSTANCE -t
SCHEMA1.MYTABLE

CDC Replication marks the unload end point in the table named MYTABLE in the specified schema for the specified instance.