- the Sybase Replication Server product has been around for (at least) 20 years

- SAP bought Sybase (the company) about 7 years ago (give or take a year?)

- SAP has been slowly eradicating the 'Sybase' name from its product inventory

------------------------------

What this means:

- what was once called 'Sybase Replication Server' is now called (by SAP) 'SAP Replication Server' [NOTE: Long time users of the product still refer to the product as 'Sybase Replication Server' ... LONG LIVE SYBASE!! :-P ]

------------------------------

Yet more confusion:

- SAP has another product with 'Replication Server' in the name, namely, the 'SAP Landscape Transformation (SLT) Replication Server' (that's a mouthful), also referred to as 'SLT Replication Server', and in some cases simply 'SAP Replication Server' (usually by folks who only know about the SLT version and are unaware of the Sybase/SAP version)

Soooo, which product are *you* referring to when you say 'SAP Replication Server'? The SLT Replication Server or the previously-named Sybase Replication Server? :-)

Assuming your reference to 'SAP Replication Server' is the latter ... then there's (obviously?) no difference in the products (ie, they're the same thing).

However, there is an exception ... per the Sybase Replication Server, Heterogenous Guide (section 14.4) ... DDL replication *is* supported when the primary database is one of {Oracle, MSSQL, IBM DB2/UDB} and the replicate is HANA. According to that same section of the manual, DDL replication is limited to:

- create table

- alter table (add/drop column)

- rename table

- drop table

NOTE: I'm just quoting the manuals; if you need more details you'll need to a) wait for someone to respond to this Q&A with more details, b) open a case with SAP or c) try it out and see what happens.

The Sybase Replication Server, Heterogenous Guide for both of the currently supported versions (15.7.1, 16.0) have references to Oracle 10g, 11g and 12c. If you've got another Oracle version in mind then I'd suggest you contact SAP sales and/or tech support for more details.