CODEWITHSUNDEEP
databaseoracle-databasetalend
arty
arty

Reputation: 11

Talend how to copy one db to another

I need to copy a lot af tables from one db to another. And i want to do it in a fast way. So, what it the fastest way to do that? I'm new to talend, i know that is possible to do something like that: toracleinput->map->toracleoutput. But it will take a lot of time to do it for 40 tables.

Upvotes: 1

Views: 3601

Answers (1)

UmeshR
UmeshR

Reputation: 833

If you want to transfer all the tables then you can use tTransferDatabase refer document pages for more details.

You can download tTransferDatabase component from above link and then install it with TOS.

once that is done this component will be displayed on palate. drag and drop it on job designer. configure like below.

  1. it will ask for source connection and target connection.
  2. Create tOracleConnection for Target & source and provide it to tTransferDatabase component.
  3. Select Migration type " schema & data".
  4. See image for more details. enter image description here enter image description here enter image description here

Upvotes: 2

Related Questions