Data Migration

[Fisher Daniel]

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]

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]

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]

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]

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]

Daniel,
Perhaps this will be of help:

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

Good Luck,
Avi.

[Fisher Daniel]

Dear all,
Thanks all for your help...
Is it possible to use Oracle SQL Loader to do data migration?

thanks
daniel

[Avi Abrami]

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.