Configuration of the Create Table Command with Row Store and Column Store

When replicating the create table command and initializing replicate tables during materialization, Replication Server supports the configuration to decide whether to store tables in rows or in columns into the SAP HANA database. In previous releases, you can only store tables in rows into the SAP HANA database, with the new configuration in 15.7.1 SP204, you can also configure to store tables in columns into the SAP HANA database.

Replication Server adds a new configuration parameter dsi_ddl_create_column_table in the replicate Replication Server at both the server level and the connection level. The default value is off. When you set the parameter to on, Replication Server issues the create column table command when sending the create table commands to the replicate database.

At the connection level, use the alter connection command to set the configuration for the SAP HANA database. Use the admin config, 'connection' command to check the configuration results.

At the server level, use the configure replication server command to set the configuration for all connections in the server. Use the admin config command to check the configuration results.