How to load multiple tables at the same time from db1 to db2

Highlighted
Six Stars

How to load multiple tables at the same time from db1 to db2

I have list of 200 tables. All are different.
I want load them from db1 to db2.
Don't want to specify schema.
I want to do it like
Insert into db2.table1 select * from db1. Table 1.
I don't have enterprise edition.
Thirteen Stars

Re: How to load multiple tables at the same time from db1 to db2

If you are using enterprise edition you can use dynamic schema option to all 200 table by using single job.in open source tool,you don't have dynamic schema option.
Manohar B

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.