Technology of data exchange between MySQL and Oracle databases?

Question

MySQL

Which technology, in your opinion, is the most optimal for data exchange between MySQL and Oracle databases hosted on different servers. Online exchange is not a prerequisite, you can transfer data for a day of work at night. Advise exchange in the form of XML files.

What do you recommend?

Answer 1

If the data structures are different, you can't do without crutches.
XML gives a chance to use ready-made utilities and inflates the volume.
If the amount of data is small, then XML.
If you need to transfer from a gig, then it is better to immediately generate SQL in the desired dialect.

Answer 2

Perhaps not your case - but with a similar task, I would start looking towards ODBC

Answer 3

two way exchange? or it is enough to make Oracle -> Mysql?
in this case, use the Oracle Gateway for ODBC (depending on the version of Oracle, it may already be installed), if the OS is windows, then usually there is no gap, on Linux 64 it is quite possible to use commercial ODBC drivers.
if two-sided, then except for GoldenGate, I probably won’t tell you anything.
it all depends on the task, if you describe in more detail, I will try to throw options.

Answer 4

The volumes are ridiculous, so any method will do. So minimize human involvement and maximize reliability.
On the Oracle side, read up on external tables. Physically, such a table can be a text file, or it can be an ODBC connection directly to the MySQL database.

Answer 5

If there is no need to synchronize data online, then the following method can be recommended.
Upload a text file from MySQL and load it into Oracle using SQL*Loader .