Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Data Migration

 
Fisher Daniel
Ranch Hand
Posts: 582
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear all,
I want to migrate the old data into new database.
How can we do data migration using JDBC from a database to the others?

thanks
daniel
 
Ben Souther
Sheriff
Posts: 13411
Firefox Browser Redhat VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It would help if you could tell us what RDMS you are moving the data to and from. Version numbers might help too.
 
Fisher Daniel
Ranch Hand
Posts: 582
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear all,
Maybe my previous posting is not clear about what database I use.
The old data is stored in Oracle8i/Oracle9i Database.
And my new application is using Oracle9i database.

Hope this clear for you to help me...

Thanks a lot...

daniel
 
Shailesh Chandra
Ranch Hand
Posts: 1082
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Daniel,

I think the easiest way is to migrate data in your case is export and import utility of oracle.

for export

exp userid/password@oracleservicename file=c:\FileName.dmp ( rows = 0 if only structure is required )

for import

imp userid/password@oracleservicename file=c:\FileName.dmp fromuser= ? touser= ?


thanks
Shailesh
[ January 21, 2005: Message edited by: Shailesh Chandra ]
 
Fisher Daniel
Ranch Hand
Posts: 582
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear all,
Thanks for you help...
I will try to do that.

By the way, I am just curious.
What about if my old data are exist on MySQL or SQL Server Database?
Are there tool (commercial or open project) to do that?

thanks a lot
daniel
 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Daniel,
Perhaps this will be of help:

http://www.oracle.com/technology/tech/migration/index.html

Good Luck,
Avi.
 
Fisher Daniel
Ranch Hand
Posts: 582
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear all,
Thanks all for your help...
Is it possible to use Oracle SQL Loader to do data migration?

thanks
daniel
 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Daniel,
Yes, SQL*Loader can be used for migration. Dump the contents of the source database to plain text files, and then use SQL*Loader to load the data from the text files into the Oracle database.

Good Luck,
Avi.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic