Does anyone have experience of realtime data sharing between a MySQL database and an Oracle database? I would really like to have them talk server to server as remote databases, but if this is too much to ask for, perhapse the communication could be through an intermediary program/app. Anyone here have knowledge of such a system, or have pointers to good web resources for asking/answering this sort of question?
Thanks, Bippy
I don’t know if they can talk directly (I suppose it’s possible). But if not, Perl’s DBI classes are excellent at abstracting the interfaces to many databases, including Oracle and MySQL. So depending on the complexity of the requirements, it would be anywhere from trivial to a Real Pain In The Ass to do it with Perl.
Thanks Friedo I’m considering a java (JODBC, etc) application for a similar result. But it would be nice if the databases work together transparently in a similar fashion to useing Net8 between two Oracles.
I don’t have any personal experience, but here is a webpage on the MySQL site that shows various tools to move databases between various SQL implementations and MySQL.