replication mysql and maxdb

[Former Member]

good morning

Please can someone help me to make replication between mysql and maxdb (if it's possible).

thanks

[markus_doehr2 · Accepted solution]

What do you want to "replicate"?

Markus

[Former Member]

thanks Wolfgang

I have a CMS that use mysql and I mustn't change it .

please have you some tutorials explaining how to use MaxDB Synchronization Manager and what is the version of maxdb that support it.

[Former Member]

Hello,

you can start here

http://maxdb.sap.com/doc/7_6/72/7ed43fb9490c65e10000000a114b1d/content.htm

and

http://maxdb.sap.com/doc/7_6/42/105f593fa3742ee10000000a114cbd/content.htm

and

http://maxdb.sap.com/doc/7_6/67/73f34026d70b06e10000000a155106/frameset.htm

With the installation there comes an example document. (sdb\programs\app\syncman\example\doc)

Regards

Wolfgang

[Former Member]

hello

thank you wolfgang .

I will try it and i will tell you about the result.

[Former Member]

yes for a SAP system, can a database notify an external program because i can't use a program that connect all time to the database to check if there are any changes(it's not a good idea )

thanks

[markus_doehr2]

Not by default.

The question is - what are you trying to accomplish with such a setup?

You can use an higher level abstraction like ALE to synchronize data.

Markus

[Former Member]

Hello,

the MaxDB Synchronization Manager can use a MySQL database for unidirectional replication. Changes in the MaxDB can be replicated to a MySQL database but not the other way. I have to admit that this feature is not heavily tested.

Just I would like to know. Why don't you exclusively use MaxDB as a database? If so you could use the Loader or the Synchronization Manager for replication.

Regards

Wolfgang

[Former Member]

have you any idea about how to synchronize them using an external program.

and can a database notify an external program if there are any changes.

habib

[markus_doehr2]

that would be your smallest problem.

The bigger problem is, that the data structures differ, you would need to "map" them somehow.

Are you talking about a SAP system?

Markus

[Former Member]

I want to synchronize 2 databases(Mysql and maxdb)

thanks Markus

[markus_doehr2]

Those are two different products and can´t be "synchronized" on database level.

Markus