[resolved] DB migration using dynamic schema

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous · Accepted solution]

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

[Anonymous]

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