topic Re: migrate my 1000 tables structures from one database to another database in an single run ? in Talend Studio

migrate my 1000 tables structures from one database to another database in an single run ?

TamilM — Mon, 24 Apr 2017 12:48:40 GMT

Do we have any option in talend to migrate my 1000 tables structures from one database to another database in an single run? since my dynamic schema option is not working for this (dynamic schema option only works when the source is having a data) .

Re: migrate my 1000 tables structures from one database to another database in an single run ?

Sid3 — Mon, 24 Apr 2017 14:36:59 GMT

Hi,

you can copy tables using below job.

parameterize your source db and target db.

put the below query in tOracleRow component

"create table "+context.tgt_db_name+"."+((String)globalMap.get("tOracleTableList_1_CURRENT_TABLE"))+" as select * from "+context.src_db_name+"."+((String)globalMap.get("tOracleTableList_1_CURRENT_TABLE"))+" where 1=0;"

Re: migrate my 1000 tables structures from one database to another database in an single run ?

TamilM — Wed, 26 Apr 2017 06:48:39 GMT

Hi Sid4U, Thanks for your input on this, but i am unable see your screenshot , can you explain me in detail ? or update a attachment. Thanks

Re: migrate my 1000 tables structures from one database to another database in an single run ?

Sid3 — Thu, 27 Apr 2017 07:58:39 GMT

I can clearly see the image in my previous post. anyway attaching again

Re: migrate my 1000 tables structures from one database to another database in an single run ?

Anonymous — Thu, 11 May 2017 11:54:32 GMT

I'm not sure that job will work since we are dealing with only one database.

What's about copying structure from Oracle database to MySQL database? Or maybe two different instance Oracle DB

Re: migrate my 1000 tables structures from one database to another database in an single run ?

cterenzi — Thu, 11 May 2017 14:04:39 GMT

As he said:
parameterize your source db and target db.

Where you send the data is up to you.

Re: migrate my 1000 tables structures from one database to another database in an single run ?

Anonymous — Thu, 28 Sep 2017 16:12:20 GMT

My suggestion :

toracleTable_list --- iterate ---> toracleinput(schema should be dynamic) ------- main ----------> toracleoutput / tmysqloutput (schema should be dynamic)

You will get tables name from toracletable_list

Re: migrate my 1000 tables structures from one database to another database in an single run ?

Anonymous — Tue, 16 Jan 2018 08:48:24 GMT

By the way,have you solved this problem?What is the specific settings of tOracleRow ? I have the same problem. I want to copy 50 tables from one database to another database. Can I have your attention,please?

Re: migrate my 1000 tables structures from one database to another database in an single run ?

Anonymous — Wed, 17 Jan 2018 06:28:10 GMT

Have you run the job successfully? I have set the same job,but the job does not work,the third one has problems. If you have any time ,please tell me how to set the three parts of the job. Thank you very much.

Re: migrate my 1000 tables structures from one database to another database in an single run ?

Anonymous — Tue, 05 Jun 2018 16:07:48 GMT

Sure,

The job is running perfectly.
But you can only do it with professional version.