SQL Server Capture Parameters

The following parameters are valid for the SQL Server Capture process:

Process Parameters

• process – The only appropriate value is capture
• id – The Capture Process id
• dbtype – The appropriate value is mssql
• name – Name of the Capture Process

Database Connectivity

• server – Host name or IP address of the database server
• port – Database port
• dbname – Database name
• user – Database User name
• password – Database User password

DML/DDL Replication Objects Specification

• ddlinclude – Mask of the DDL objects to be captured
• ddlexclude – Mask of the DDL objects to be skipped by the Capture Process
• dmlinclude – Mask of the DML objects to be captured
• dmlexclude – Mask of the DML objects to be skipped by the Capture Process
• skipapply – Used to define the behaviour of a Capture Process when extracting data, which was produced by Apply Processes as part of the “loop-back” control function, in that, this Capture Process will extract or ignore the data. The Apply Processes to be skipped are specified by ids separated by comma. In order to specify all Processes the “all” value to be used. In order to avoid skipping any Apply Processes the “none” value to be used. The default value is “all”.
• map – The set of the parameters to determine global objects’ transformation

See Capture Objects Specification for the DML and DML objects specification details and Objects Mapping and Possible Transforms for the objects' transformation details.

Initial Load Objects Specification

• loadinclude – Mask of the objects to be included into the Initial Load
• loadexclude – Mask of the objects to be skipped during Initial Load

See chapter Initial Load for more details.

Other Parameters

• poolingdelay – The parameter is used to specify number of seconds the Capture Process will wait after each database changes gathering
• preview – This parameter is used to validate list of the tables to be included into the replication along with the transformation rules. The possible values are:
  • 0 – do not use “preview” mode (default)
  • 1 – do not apply the configuration to the Capture Process but provide the list of the tables to be included into the replication along with the transformation
• autostart – Determines if the Process must be run automatically, the possible values are:
  • 0 – do not run the Process automatically (default value)
  • 1 – to run the Process automatically
• debuglevel – The level of debugging, possible values are 0-15, the default value is 0