[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
Highlighted
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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now