export table from ORACLE to SYBASE

[mjain]

Hello,

Can anyone please help me in exporting data from ORACLE 8.1 to Sybase 12.0. The table is in ORACLE & I want to transfer data to Sybase table.

Cheers.

[rotem_fo]

Hi,
You need to extract data from Oracle and upload it to Sybase.
You can spool the data from sqlplus (rather slow) or you can use an unload utility such as BMC's Unload for Oracle (very expensive).
There is a free tool called granger unload (available at http://www.datatransformations.com/download.htm) and it is very helpfull.

Simply extract data from oracle tables and use the Sybase BCP utility to load the data.

Cheers,
R.

[mjain]

Cheers.

[balajiyes]

There's an article:
http://www.eweek.com/article2/0,3959,293,00.asp

You can read about benchmarks at:
http://www.tpc.org
Cheers!

[frank_alw]

Originally posted by rotem_fo
Hi,
You need to extract data from Oracle and upload it to Sybase.
You can spool the data from sqlplus (rather slow) or you can use an unload utility such as BMC's Unload for Oracle (very expensive).
There is a free tool called granger unload (available at http://www.datatransformations.com/download.htm) and it is very helpfull.

Simply extract data from oracle tables and use the Sybase BCP utility to load the data.

Cheers,
R.

There is another third party product FastReader from WisdomForce. www.wisdomforce.com. FastReqaader allowing unload large oracle tables into text file and creates input for loaders like sql loader* or others. Hope it helps

[DaPi]

Originally posted by rotem_fo
You can spool the data from sqlplus (rather slow) . . .

This is slow if you send the data across the network. You could perhaps run SQLPLUS on the server, or write files with UTL_FILE (no newtork layers getting in the way). But if the free utility fits the bill, no need.