SiteExperts.com Logo Home | Community | Developer's Paradise
User Groups | Site Tools | Site Information | Search
 Main Menu
 Forums
SiteExperts.com Forums
All Discussions

SiteExperts Feedback
The Lounge
Dynamic HTML
Site Design/ Critiques
HTML and CSS
XML Technologies
The Wireless Internet
Internet Explorer
Microsoft .NET
The Server
Technical Support

Sponsored Links

User Groups : Forums : SiteExperts : The Server :

Previous DiscussionNext Discussion
 migration from oracle to db2?

Happy New Year

I have an application ready with db oracle but I also need this application to be set with db2. How to export tables & its data from oracle to db with ease? I surf the net but not written in easy way.

Looking forward for a early reply

Thanks

 

Started By pashah72 on Dec 31, 2005 at 5:36:12 AM

18 Response(s) | Reply

View All Replies | Goto Page: 3 2 1
BachusII on Jan 10, 2006 at 2:49:39 AM

Pardon me for butting in, but what stops you from:

  • Copying your oracle database to a oracle_tmpDB
  • Running that tool to copy 10 tables from oracle_tmpDB to DB2_tmpDB_1
  • Deleting those tables from oracle_tmpDB
  • Re-running the tool to copy a further 10 (or less) tables from oracle_tmpDB to DB2_tmpDB_2
  • (repeating the previous two/three untill all tables are copied)
  • Merging the several DB2_tmpDB_* into one DB2_tmpDB
  • Thoroughly checking DB2_tmpDB
  • And finally copying and using it for whatever you want

View All Replies | Goto Page: 3 2 1

To respond to a discussion, you must first logon.

If you are not registered, please register yourself to become a member of the SiteExperts.community.

User Name
Password
Copyright 1997-2000 InsideDHTML.com, LLC. All rights reserved.