topic Re: Copy 100+ tables from one database to another database in Talend Studio

Copy 100+ tables from one database to another database

Anonymous — Sun, 23 Oct 2016 06:23:40 GMT

Hi,
I have Enterprise version Talend. I need to copy tables from one database to another database. I am looking dynamic schema option and the below link is not working and I see this link in several posts.
If anyone know how to copy tables from one database to another using dynamic schema let me know.

Thanks.

Re: Copy 100+ tables from one database to another database

Anonymous — Sun, 23 Oct 2016 06:25:43 GMT

Here is the link:

Re: Copy 100+ tables from one database to another database

vapukov — Mon, 24 Oct 2016 14:24:10 GMT

If You use Enterprise version of Talend, it is already support Dynamic columns, so You can make a loop:
1) read all tables names from Source (from information schema for example)
2) convert flow to iterate and for each row store names to variable
3) make a universal job - source table -> target table. Use variable as table name and single column with Dynamic type

If You use community version - check Talend Exchange for components (if it present for Your database)

Re: Copy 100+ tables from one database to another database

Anonymous — Fri, 01 Nov 2019 16:18:49 GMT

Hi!

How did you resolve it?