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.
1 REPLY
Twelve 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