Can we copy all the tables of the schema to another schema in another db at once using jasper etl job?

0

Can we copy all the tables of the schema to another schema in another db at once using jasper etl job?

I tried tmysqlInput and tmysqlOutput corresponding to each table in database which i think is not good approach.

aamitt06's picture
147
Joined: Jun 23 2014 - 5:48am
Last seen: 4 years 4 months ago

1 Answer:

0

It's possible to copy data from one database to another but more difficult to copy metadata information from one database to another database especially if they are different (different database product, different version/release).

If you are just going to copy dataa from same type of database, use a tool provided by database provider instead of etl because it offer better performance and failure recoverly.

hozawa's picture
64760
Joined: Apr 24 2010 - 4:31pm
Last seen: 1 year 3 months ago

Thanks for suggestion but I have two same database type and I have to copy all metadata information from one database to other using ETL job.

aamitt06 - 6 years 2 months ago
Feedback
randomness