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: Stephen Evans <evans036_at_mc.duke.edu>
Date: Wed, 29 Jan 2003 07:54:06 -0800
Message-ID: <F001.0053D554.20030129075406@fatcity.com>


vijay,

oracle has a free product call 'Oracle Migration Workbench' that i understand is very good at transferring objects & data from sybase to oracle.

however, i do believe that schemas (ie table structures) need to be the same - or at least will be created the same in the oracle database. you could possibly use this product to at leastget your data into oracle & then massage it into your new structures.

good luck,

steve

"Vijaya Chander V.S" <srinivasa_v_at_infosys.com> Sent by: root_at_fatcity.com
01/29/2003 07:49 AM
Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        migration from Sybase to Oracle


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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Stephen Evans
  INET: evans036_at_mc.duke.edu

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 Wed Jan 29 2003 - 09:54:06 CST

Original text of this message

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