Can IQ support being the primary server of Sybase Replication Server?

[former_member232292]

Dear All,

    I'm using Sybase replication server transferring data between ASEs. But in the Sybase Replication Server Heterogeneous Replication Guide, I see the Sybase   IQ can only be replicate server -- so does it mean Sybase IQ can't be the datasource for Replication server?

    Is that right? Thanks

Regards

Eisen

[c_baker · Accepted solution]

The simple answer is 'No'.  IQ cannot be a source for SRS, only a target.

The long answer is - IQ does not have a transaction log to be a source as SRS understands it.

Question: Why would you want to take data out of IQ in a transactional manner?

Chris

[former_member232292 · Accepted solution]

Thank you Chris.

I think so too -- it's just because customer want to copy some tables from IQ to Hana and keep them synchronized...

[c_baker · Accepted solution]

This is the purpose of HANA Extended storage and Data Warehouse Foundation/Data Lifecycle Manager.  You can move data between HANA and IQ and provide a unified view between the data in the tables.

http://help.sap.com/hana/SAP_HANA_DWF_DLM_Administration_Guide_en.pdf

Chris

[former_member232292 · Accepted solution]

thank you. Chris

[former_member354103]

Hi c.baker,

Can we replicate data from primary Sap IQ Node to Secondary Node live to live for Disaster recovery perspective.

Kindly Suggest any suitable solution.

Regards,

Muhammad Shafiq