cancel
Showing results for 
Search instead for 
Did you mean: 

Replication Server Sybase ASE to Oracle and DDL

0 Kudos

1/ Are there any differences between Sybase Replication Server and SAP Replication Server ?

2/ Is there a possibility of replicating DDL commands between Sybase ASE to an Oracle replicate ? If, yes, what are the limitations.

3/ What are the other limitations (data types ...) when replicating from Sybase ASE to Oracle ?

4/ Which edition of the Replication Server is required in this case ?

5/ What are the compatible oracle versions and sybase ASE versions ?

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member89972
Active Contributor
0 Kudos

Have not use SAP SLT RS so my comments are limited to SYBASE RS.

1. Sybase RS is log (transaction log) based ( I have read that SAP SLT RS is trigger based )

2. DDL across two different flavors of RDBMs may not be useful except very simple SQL for table/views creation. So most probably not.

3. There are no limitations of data types but you will need to be careful when replicating special types like identity, or LOBs, table ownership etc.

4. Sybase RS 15.7.1 and later have licensed feature called ECO (express connect to oracle)

This makes it easy to set up ASE to Oracle replication. ASE 15.5, 16.0 and Orcle 9/10/11/12 all are supported

You can see the documentation of latest Sybase RS.

Earlier Sybase RS versions supported ASE to Oracle replication with a gateway called DCO (Direct connect to Oracle)

5. With Sybase RS 15.7.1 : you can go for the latest on either side ASE 16.x and Oracle 12.x

HTH

Avinash