Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: migration from Sybase to Oracle

RE: migration from Sybase to Oracle

From: Adrian Roe <Adrian.Roe_at_telewest.co.uk>
Date: Thu, 30 Jan 2003 05:58:43 -0800
Message-ID: <F001.0053E79B.20030130055843@fatcity.com>


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).

Live Life in Broadband
www.telewest.co.uk

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US