[resolved] DB migration using dynamic schema

One Star

[resolved] DB migration using dynamic schema

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

Accepted Solutions
Community Manager

Re: [resolved] DB migration using dynamic schema

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
----------------------------------------------------------
Talend | Data Agility for Modern Business

All Replies
Community Manager

Re: [resolved] DB migration using dynamic schema

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: [resolved] DB migration using dynamic schema

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
Community Manager

Re: [resolved] DB migration using dynamic schema

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: [resolved] DB migration using dynamic schema

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