ra_add_table

Syntax

ra_add_table modelName, primaryTable, replicateTable, 
create=[true|false], 
replace=[true|false], 
materialize=[true|false], 
deferReplication=[true|false]

Parameters

modelName – specifies the name of the replication model.
primaryTable – specifies the primary SAP HANA database table name.
replicateTable – specifies the replicate SAP HANA database table name.
create – creates the table at the replicate SAP HANA database, if the table in the primaryTable parameter does not already exist. Valid values are true or false.
replace – replaces the table at the replicate database, if it exists. Valid values are true or false.
materialize – determines whether to materialize the table. Valid values are true or false.
deferReplication – determines whether to defer replication of a table, if there is no data in that table. Valid values are true or false.
Use the deferReplication parameter to instruct Replication Agent for SAP HANA not to create the table at the replicate database, if there is no data stored for replication.

Examples

Example 1 – Adds a primary SAP HANA database table named sap_hana01 in the list of tables for replication with materialization:
```
ra_add_table HANA2HANA, sap_hana01, materialize = true, 
go
```
Example 2 – Adds the table named sap_ha334 with an option to defer replication:
```
ra_add_table HANA2HANA, sap_ha334, deferReplication = true
go
```

Example 3 – Includes all tables that start with soa for replication:

ra_add_table HANA2HANA, soa*, *, create=true, replace=true, materialize=true, deferReplication=false
go

Usage

Set the materialize parameter to populate the replicate table from the primary table before beginning trigger-based replication.

Note: In the CDC strategy, the materialize parameter populates the replicated CDC tables.
Use a wildcard to specify table names. For example, you can use an asterisk (*) to specify “TABLE_PREFIX*”, which includes all tables that start with TABLE_PREFIX for replication. If you use the wildcard, the replicateTable parameter must be set to “*”.