This week's giveaway is in the EJB and other Java EE Technologies forum. We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line! See this thread for details.
While it wouldn't be hard to write JDBC code that does a SELECT in one DB, and then an INSERT into the other DB, that's not the best approach. Just about all DBs have their own facilities for bulk-exporting and bulk-importing data; that area is called ETL (extract, transform, load) - check the documentation of the involved DBs for what they support.
Ping & DNS - updated with new look and Ping home screen widget
Joined: Apr 08, 2004
I guess ETL is third party product like Informatica. It is not part of the DB. I want the option that's part of the DB or thru JDBC.
Joined: Mar 22, 2005
No, ETL is a tool category; check its Wikipedia page if you're unsure about the term. There are certainly 3rd party products for this, but:
Just about all DBs have their own facilities for bulk-exporting and bulk-importing data ... check the documentation of the involved DBs for what they support.