DDL Replication Support in Heterogeneous Replication Environment

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

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.

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.
DDL Replication Support in Heterogeneous Replication Environment in the Heterogeneous Replication Guide.