Skip to Content
0
Former Member
May 30, 2011 at 04:56 PM

Crazy idea: Database replication / table replication for SAP system

63 Views

We are looking for a solution to replicate part of SAP ECC tables into another SAP ECC system, realtime & sychnorized!

A functional team is leading the solution from SAP functional point of view, such as sycn all the business orders to keep tables synchronized. I want to know the possibility on technical level.

What I know is it's almost impossible, the possible solutions are as follows:

1) DataGuard on whole DB level.

Question: Can this support serveral destinations sync, for example, database A to database B&C&D? The DB sid must be the same? Can destination DB start as readonly mode when sync? Can SAP start during sync to support ECC query/report? As I know, even after user login, some tables need to be updated...

2) Replication on table level. According to note 105047, there are some build-in replication tools:

2.1) Advanced Replication, supported

2.2) Streams, can not be used

2.4) Materialized Views, supported

2.3) Trigger, supported with Materialized Views but cannot use trigger-based real-time replication

Question: Which one can be used for replicating ream time huge SAP transaction tables? Only support Z/Y cutomized talbe or even support standard tables?

3) 3rd party replication product, such as sybase replication agent for oracle, others....

Question: Comparing with oracle build in functionality, they are better or worse?

I know this is crazy but still need your input regarding this.

Thanks

James