Win a copy of Java Challengers this week in the Java in General forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • paul wheaton
  • Devaka Cooray
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Liutauras Vilda
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
  • Piet Souris
Bartenders:
  • salvin francis
  • Mikalai Zaikin
  • Himai Minh

Data Migration

 
Ranch Hand
Posts: 582
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Sheriff
Posts: 13411
Firefox Browser VI Editor Redhat
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 1087
Oracle Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 1143
1
Eclipse IDE Oracle Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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: 1143
1
Eclipse IDE Oracle Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Tomorrow is the first day of the new metric calendar. Comfort me tiny ad:
Thread Boost feature
https://coderanch.com/t/674455/Thread-Boost-feature
reply
    Bookmark Topic Watch Topic
  • New Topic