Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: migration from Sybase to Oracle
Best option is to use bcp to get the data out of Sybase ino a flat file,
then use SQL*Loader to get the data into some Oracle staging tables. You can
then use pl/sql procs to move the data to it's final destination.
Ade
-----Original Message-----
Sent: 29 January 2003 12:49
To: Multiple recipients of list ORACLE-L
Hi Everyone,
We need to migrate data from a Sybase DB to Oracle 9i DB and both the data
models defer a lot.
Is there any tool available for this kind of migration. Can we do this
migration with out any tool.
If yes please let me know like how should we go about this migration.
If there are any websites/ checklist on effort estimation till
implementation please share with me.
Thanks in advance.
Regards,
Vijay
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vijaya Chander V.S
INET: srinivasa_v_at_infosys.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Adrian Roe
INET: Adrian.Roe_at_telewest.co.uk
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Jan 30 2003 - 07:58:43 CST
![]() |
![]() |