aamitt06 Posted July 22, 2014 Share Posted July 22, 2014 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. Link to comment Share on other sites More sharing options...
hozawa Posted July 23, 2014 Share Posted July 23, 2014 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. Link to comment Share on other sites More sharing options...
aamitt06 Posted July 23, 2014 Author Share Posted July 23, 2014 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now