Replication Agent and SAP® Replication Server® support replication of several data
definition language (DDL) commands in a heterogeneous replication environment when the
replicate is an SAP HANA database.
Replication Agent
and Replication Server supports replication of these DDL commands into SAP HANA database
when the primary database is Oracle, Microsoft SQL Server, or DB2 UDB:
- create table
- alter table (add column or drop
column)
- rename table
- drop table
With this enhancement, Replication Server
automatically alters the database replication definition to reflect any DDL changes in a
database that is marked for replication at the database level, if database replication
definition is defined with the auto_update_table_list or
auto_extend_table_list parameter. For example, if a database is
marked for replication and a table is subsequently added to the database, replication is
automatically established for the newly added table.
Note that a table that is created, altered, renamed, or dropped is not normalized by the
table replication definition except for the replicate table owner, if:
- The replicate table owner defined is in the table replication definition, and
- The replicate site is subscribed to the table replication definition.
See:
- SAP Replication Server Reference Manual > Replication Server Commands >
create database replication definition.
- SAP Replication Server Heterogeneous Replication Guide > SAP HANA Database
as Replicate Data Server > DDL Replication in Heterogeneous Replication
Environment.