topic Re: [resolved] DB migration using dynamic schema in Talend Studio

[resolved] DB migration using dynamic schema

Anonymous — Tue, 08 May 2012 08:35:03 GMT

Hi,
I have two databases, and one of them is empty. What I want to do is to take all the tables and the rows from the first database and put them in the second one. I thought that this would be posible with the Dynamic Schema from Team Edition.
Is there any way to use the Dynamic Schema to achieve this?
Regards,
Khor

Re: [resolved] DB migration using dynamic schema

Anonymous — Tue, 08 May 2012 08:46:08 GMT

Hi,
Yes, it is possible with dynamic schema feature. The job looks like: (let's take Mysql for example)
tMysqlTableList--iterate--tMysqlInput--main--tMysqlOutput
on tMysqlOutput, set a dynamic table name:
((String)globalMap.get("tMysqlTableList_1_CURRENT_TABLE"))
and select
'create table if not exist' option in the action on table list.
Best regards
Shong

Re: [resolved] DB migration using dynamic schema

Anonymous — Tue, 08 May 2012 08:58:09 GMT

Hi shong,
How can I "activate" the dynamic schema feature? Because I get an error when I try to run the job saying that I haven't set the schema yet.
And how i have to write the query? My one looks like this and i get an error too:

"SELECT *
FROM "+((String)globalMap.get("tMysqlTableList_1_CURRENT_TABLE"))

Thanks,
Khor

Re: [resolved] DB migration using dynamic schema

Anonymous — Tue, 08 May 2012 09:32:48 GMT

Hi
The dynamic schema feature is only available on Talend Enterprise Data Integration, if you are using commercial subscription version, you can use it directly without activating it.
The query is OK for me.
Best regards
Shong

Re: [resolved] DB migration using dynamic schema

Anonymous — Tue, 08 May 2012 09:44:56 GMT

Hi shong,
Thanks, you helped me a lot!
Have a nice day
Khor