topic Re: from Oracle dump file into MySQL Database in Talend Studio

from Oracle dump file into MySQL Database

Anonymous — Sat, 16 Nov 2024 12:42:14 GMT

Hi,
I have a new project.
The DBAs from remote Oracle Database will give me the dump files for each table.
I'll have to load them into local MySQL Database.
Is there any direct way to load from Oracle DUMP file into MySQL?
Because, current strategy is that, we will get the .dmp files from remote oracle db,
load it inot local oracle db and then migrate it into local mysql db.
This seems a little complex and a lot of steps.
So, I'm thinking it would be better if I can load the .dmp file from remote oracle db directly into local mysql db.
Please advise....
Thank You.

Re: from Oracle dump file into MySQL Database

Anonymous — Wed, 07 Sep 2011 16:05:07 GMT

Hi
No, it is impossible to load the .dmp file from remote oracle db into local Mysql DB using Talend, you have to load the data into local oracle and then migrate it to mysql.
Best regards
Shong

Re: from Oracle dump file into MySQL Database

Anonymous — Wed, 14 Sep 2011 09:01:37 GMT

soga