STRDTAMIR - Start net change mirroring

Use this command to start net change mirroring on a subscription.

This command starts mirroring of any table with a replication method set to mirroring, and a table status set to Refresh or Active.

Applies To—Source

Syntax

Table 1. Supported keywords
Keyword	Description	Choices	Notes
TARGET	Subscription name	`Name`, generic, ALL	Required
IDLE	Idle format	WAIT, END	Optional
FORMAT	Net change mirroring format	NO, ONLY	Optional
BLOCKING	Blocking describe	NO, YES	Required

Specifies the name of the subscription.

This is a required parameter.

Name: Specify the name of a subscription. This must be the same name defined in Management Console.
generic*: Generic names may be used for subscriptions, by adding an asterisk (*) after one or more characters that are common to the group of subscriptions names. For example, 'abc*' specifies all subscriptions starting with the characters 'abc'.
*ALL: Specifies all subscriptions.

Specifies the action that CDC Replication will take when it determines that all available data has been replicated to the target.

*WAIT: CDC Replication replication process remains active after all changes are replicated to the target.; This is the default setting.
*END: CDC Replication replication process ends after all changes are replicated to the target.

Indicates if CDC Replication should start net change mirroring.

*ONLY: Indicates that CDC Replication will not start net change mirroring.
*NO: Indicates that CDC Replication will start net change mirroring.; This is the default setting.

Indicates whether the STRDTAMIR command will block until the describe completes.

*YES: The STRDTAMIR command will not complete until the describe is complete.
*NO: The STRDTAMIR command will not wait until the describe is complete before being executed.; This is the default setting.

Messages are placed in the Event Log.

STRDTAMIR TARGET(SUB1) IDLE(*END)

CDC Replication starts net change mirroring on subscription SUB1. All CDC Replication processes end after all available data has been mirrored.

STRDTAMIR
TARGET(SUB1) IDLE(*END) FORMAT(*NO)

CDC Replication starts net change mirroring on subscription SUB1. All CDC Replication processes end after all available data has been mirrored.

STRDTAMIR
TARGET(*ALL) IDLE(*END) FORMAT(*NO)

CDC Replication starts net change mirroring on all subscriptions. All CDC Replication processes end after all available data has been mirrored.