One Star

Migrate data onto Oracle DB on MS Azure using TOS

Hi All,

 

I need to migrate data from an On-Prem Oracle database onto another Oracle DB on MS Azure.

Pls let me know if this is feasible using Talend Open Studio.

 

If yes, pls share some references.

 

Regards,

HPR

1 REPLY
Moderator

Re: Migrate data onto Oracle DB on MS Azure using TOS

Hello,

With talend open studio, you have to create many subjobs for mapping table by table in one job, because each table has different table structure, you have to create different subjob with corresponding schema, for example:

tOracleInput_1--main--tOracleOutput_1  (migrate table1)
   |
onsubjobok
   |
tOracleInput_2--main--tOracleOutput_2 (migrate table2)
   |
onsubjobok
   |
...other subjobs for other tables...

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.