Can we import a complete database from MYSQL DB to oracle DB

[_AnonymousUser]

Hi,
I have a mysql database with 40 tables. Is there a way to import all the tables from this DB into an oracle DB using a single job.
I know i can create a tMySqlInput to import each table (doing it for 40 tables), but is there a way import the complete DB in one go to oracle.
I using talend open studio 5.2.0
Thanks
Prash

[Anonymous]

Hi,
For community version, you have to create different jobs for mapping each table.
For enteprise version, you can create only one simple job for all table thanks to the dynamic schema feature, see
https://help.talend.com/pages/viewpage.action?pageId=5671283
However, dynamic schema feature is only available in Talend Enterprise Data Integration.
Best regards
Sabrina

[_AnonymousUser]

Hi,
You can use this component tTransferDatabase.
best regards

[_AnonymousUser]

Sorry,
You can download this componant here
http://www.talendforge.org/exchange/index.php?eid=457&product=tos&action=view

[Anonymous]

Hi,

You can use this component tTransferDatabase.

Because tTransferDatabase is a custom component, we provide you with the KB article Installing a custom componenton Talend Help Center.
Hope it will help you.
Best regards
Sabrina

[emdelvis]

Hi xdshi with the component tTransferDatabase is possible select only the tables that i want transfer ?
Thanks in advance

[Anonymous]

Hi,
Actually,  tTransferDatabase is a custom component written by talend community user and shared on talend exchange.
Feel free to contact the author directly.
Best regards
Sabrina