Identifying Tables in the Primary Schema

To view which tables are included in the replication model, select the host and expand the RAXContainer from the Agent Servers > Known Agents list.

1. To view the list of operations you can perform, right-click the HANA2HANA replication model and select the Primary Schema Tables menu option.
2. On the Primary Tables Schema window, enter the search filter criteria:
   • Table Include Filter – limits the table list to the tables that match with the search criteria.
   • Table Exclude Filter – excludes the tables that match with the filter search criteria from the table list.
   • Add All Tables in the Schema – adds all tables in the schema to the load script.
   • Selected Tables Only – includes only selected tables for replication.
   • Non Selected Tables Only – includes tables that are not selected for replication.

   Use the wildcard (*) to symbolize any number of any characters. For example, *ORDER matches with both NEW_ORDER and OORDER table names.

   A table that matches the search filter criteria, but is not included in the replication model, is included in the search result list with an Add check box next to it; a table that is already included has a Remove check box next to it.

3. Select or unselect tables from the Tables in Primary Schema pane for replication.
4. Select the Add or the Remove check box to include or exclude a table from the replication model.
5. Select any of these Replication Options check boxes:

   • Create – creates the table at the replicate database, if the table does not already exist.

     This refers to the replicate table not the CDC table. The CDC table is always created if it does not exist when you use either the CDC or the Transactional CDC strategy.

   • Replace – replaces the table at the replicate database, if it exists.

   • Materialize – populates the replicate table from the primary table before beginning trigger-based replication.

     For example, if the primary table, PRIMARY.T1 has one million rows in it before replication starts, Replication Agent for SAP HANA selects one million rows from the PRIMARY.T1 and applies them to the REPLICATE.T1 before moving the data to the shadow tables with the triggers. Data from the shadow tables is not applied until all one million initial rows are replicated.

     Note: In the CDC strategy, the Materialize option populates the replicated CDC tables.

   • Defer – instructs Replication Agent for SAP HANA not to create the table at the replicate database until the tables contain data that is to be replicated.

6. Click Execute to save the changes to the replication model.

   These changes are not applied to the primary or replicate database until replication begins.

7. To requery the database for the table name list, click Refresh.
   On the Status Messages panel, you can view the progress of:

   • Total Rows
   • Number of Remaining Rows
   • Average Rows/Seconds
   • Total Bytes
   • Bytes Remaining
   • Average Bytes
   • Estimated Time Remaining

   On the Table Materialization Status panel, you can view:

   • Primary Table Name
   • Replicate Table Name
   • Materialization Status
   • Progress in percentage
   • Row count
   • Rows Remaining
   • Rows/Seconds
   • Table Size
   • Other Statistical Information

   On the Status Messages panel, you can view the status messages for the Replication Options that you selected for each table from the primary to the replicate database.
8. (Optional) Right-click the model and select Save Deployment Script for <model name> to save a script of the Replication Agent for SAP HANA commands that are executed to deploy the model.
   This Deploy_HANA2HANA_For_RAXContainer.sql script might help you understand the Replication Agent for SAP HANA command reference APIs. You can execute the commands in the script in the command line interface (CLI) using a TDS client such as SAP isql utility.