This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Copy whole table from DB2 to Oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Copy whole table from DB2 to Oracle" Watch "Copy whole table from DB2 to Oracle" New topic
Author

Copy whole table from DB2 to Oracle

Pankaj.insatyam kumar
Greenhorn

Joined: Nov 30, 2005
Posts: 3
Hello,

Can anyone please let me know how can I migrate WHOLE table from DB2 to Oracle? Is there any software or so?

Regards
Pankaj
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1081

I don't know if there is any cross database utility, you must search on google for it.

I would suggest export your data either CSV or Excel or Fixed length file from DB2 and upload into Oracle usingf SQL Loader.

Thanks,
Shailesh


Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3703
    
    5

Not really. You may have some luck with export/import tools but depending on the data types used it may still require some conversions. I find the best way to do something like this is write a JDBC tool that reads a record from one database and inserts it into another after performing some conversions. The non-conversion JDBC code should be about a page long.


My Blog: Down Home Country Coding with Scott Selikoff
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1081

Yes data conversion is another area which need to be addressed, In SQL loader we can also convert the Data in desired format before inserting into table, also in term of performance I have very good experience with SQL loaders.

I used to insert approx 2 million records in oracle within 5 minutes.

Thanks,
Shailesh
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3703
    
    5

Originally posted by Shailesh Chandra:
[QB]I used to insert approx 2 million records in oracle within 5 minutes./QB]


That's easy when the database is local, try doing it when the database is across a distributed network... now *thats* fun.
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1081

Well it was a remote database on lan

Thanks,
Shailesh
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3703
    
    5

Originally posted by Shailesh Chandra:
Well it was a remote database on lan


I meant over the internet. Its fun to work on solutions for such an environment. But we're definitely off topic now ;)
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1081

Originally posted by Scott Selikoff:


I meant over the internet. Its fun to work on solutions for such an environment. But we're definitely off topic now ;)


I fully agree with you!

Thanks,
Shailesh
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Copy whole table from DB2 to Oracle
 
Similar Threads
Creating table from subset of another table in DB2
Performance problem in jdbc
Errors using Oracle XA datasource
DB2 - case sensitive or not
Revert Back Changes from Update query