Try now
Try now
Use Cases
Replication and data migration Zero downtime migration Logical standby Zero downtime upgrade Distributed clusters ''Real Time'' reporting systems and Business Intelligence
Support
Current Feature Set Documentation Professional Services Roadmap
Company
About Us Contact Us Become a Partner News Updates
Try now
Try now
Home / Repstance User Guide / 7. COMMANDS TO BE USED / 7.4 Prepare Capture Process / 7.4.4 Capture Objects Specification

7.4.4 Capture Objects Specification

Repstance allows flexibility to determine a set of tables, which are to be captured. The tables for DML and DDL operations are specified by the different parameters.

The following parameters are used for DML replication:

  • dmlinclude – list of the tables to be included into the DML replication
  • dmlexclude – list of the tables to be excluded from the DML replication

The following parameters are used for DDL replication:

  • ddlinclude – list of the tables to be included into the DDL replication
  • ddlexclude – list of the tables to be excluded from the DDL replication

Note – These criteria are mutually exclusive. The table will only be replicated in the case that the name matches the “include” criteria and does not match the “exclude” criteria.

The table is specified in schema _name . table_name format. In order to specify the list of the tables, each table must be separated by comma. The % symbol may be used in order to match any number of characters. It may also be used in both schema _name and table_name parts.

The following examples show various ways of defining tables:

  • Customers and employees tables, which are in the dbo schema:
dbo.customers,dbo.employees
  • Any tables in the dbo schema:
dbo.%
  • Any tables having name started from rep or tmp:
%.rep%,%.tmp%
  • Any table in report schema ends with #:
report.%#

The following examples show how to use the DML/DDL parameters:

  • To capture DML changes for all tables in dbo schema except where tables start with rep:
dmlinclude=dbo.%
dmlexclude=dbo.rep%
  • To capture DML changes for all tables in the cap1, cap2 and cap3 schemas except the report1 table from the cap1 schema:
dmlinclude=cap1.%,cap2.%,cap3.%
dmlexclude=cap1.report1
  • To capture DML and DDL operations for any tables in the dbo schema:
dmlinclude=dbo.%
ddlinclude=dbo.%
  • To capture only DDL operations for objects in the report schema:
ddlinclude=report.%

These parameters influence the newly created tables as well. The description below shows the capture behavior of the tables created:

 

 

Tables that match DML criteriaTables that match DDL criteriaCapture Behavior
truetrueThis create statement is captured. Any further DML statements will be captured as well
truefalseThis create statement is not captured. No DML statements will be captured
falsetrueThis create statement is captured. DML statements are not captured. However, any further DDL statements are captured
falsefalseThis create statement is not captured. Neither DML or DDL statements will be captured

 

 

 

 

 
On this page
7.4.4 Capture Objects Specification