Preface
Overview of the Server Manager Command Line Interface
Usage Scenario: Using Server Manager CLI Commands to Run Replications
- Prerequisite Tasks for Running Replication Jobs from the Server Manager CLI
- Using the Server Manager CLI to Run Replications
  - Running a Scheduled Replication Job in Interactive Mode
  - Running a Scheduled Replication Job in Non-interactive Mode with Scripts
Command Reference

Command Line Interface for the Server Manager

9.7.0 HotFix 1

Back Next

set replication mode

Enables or disables Change Data Capture for Microsoft SQL Server tables in a specific database. You can enable Change Data Capture for all of the database tables or for a subset of the tables.

Syntax

set replication mode Server_Manager_nameSQLServer_instance_namedatabase_name [mode=state] [pattern=pattern]

The following short form is acceptable:

srm Server_Manager_nameSQLServer_instance_namedatabase_name [mode=state] [pattern=pattern]

Parameters

The following table describes the command parameters:

Parameter	Description
Server_Manager_name	The name of the Server Manager instance that runs on the Microsoft SQL Server system.
SQLServer_instance_name	The name of the Microsoft SQL Server instance.
database_name	The name of the Microsoft SQL Server database.
mode	Specifies the Change Data Capture settings for the specified tables. Valid values are: on . Enable Change Data Capture. off . Disable Change Data Capture. By default, if this parameter is not specified, Change Data Capture is enabled.
pattern	A comma-, semicolon-, or space-separated list of wildcard patterns that the Server Manager matches against table names to filter the tables for which to set Change Data Capture. You can use the asterisk (*) and question mark (?) wildcards in the patterns. By default, the command sets Change Data Capture for all tables in the database.

Examples

The following command enables Change Data Capture for all of the tables in the DB_Source database of the MSSQLSERVER instance that runs on the Server Manager Main server system:

set replication mode Main MSSQLSERVER DB_Source

The following command disables Change Data Capture for all of the tables in the DB_Source database of the MSSQLSERVER instance that runs on the Server Manager Main server system:

srm Main MSSQLSERVER DB_Source mode=off

Rename Saved Search

Table of Contents

Command Line Interface for the Server Manager

Command Line Interface for the Server Manager

set replication mode

set replication mode

Syntax

Parameters

Examples