Bi-Directional Replication Between MSSQL and HANA

[Former Member]

Hi All,

Just wondering is there currently any solution in place for bi-directional replication between a SAP Business One System based on MSSQL DB and a SAP Business One system based on HANA. Both are same B1 releases and I would like to place an MSSQL setup in another site but have the data replicated back and forth between the two DB's.

I've toyed with the idea of putting another HANA instance on the site but it seems B1 does not allow asynchronous log replication of another worker node. The distance between sites is well over 100km.

[kenneth_brozovich]

As far as using SAP Replication Server for this, no, you can't do bidirectional MSSQL <-> HANA.  There may be other SAP solutions that have this capability outside of Replication Server, but I am not versed on those.