Replication Server supports replication of several data definition language (DDL)
commands in a heterogeneous replication environment when the replicate is an SAP HANA database.
Replication Server supports replication of these DDL commands into SAP HANA database when
the primary database is Oracle, Microsoft SQL Server, or IBM DB2 UDB (SAP ASE as a
primary database is not supported):
- create table
- alter table (add column or drop
column)
- rename table
- drop table
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.
Note: In a heterogeneous replication environment, the primary datatypes map to the
corresponding replicate datatypes.
See:
- Datatype Translation and Mapping in the Heterogeneous
Replication Guide.
- create database replication definition in the Reference
Manual.