RE: Oracle-->SQL Server Data transfer

look into UTL_FILE package.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----

From: Harvinder Singh [mailto:Harvinder.Singh_at_MetraTech.com] Sent: Wednesday, September 29, 2004 1:42 PM To: oracle-l_at_freelists.org
Subject: Oracle-->SQL Server Data transfer

Hi,

We need to transfer large amount of data daily from Oracle database to SQL Server Database. We have 3 options:
Use DTS of SQL Server
Use Linked server of SQL Server
Use BCP in SQL Server

First 2 options are working but since bcp is very fast we are more inclinded in using this feature. Since bcp is available in both Sybase and SQL Server for that 2 databases to transfer data is easy. So we are looking of how to extract data from Oracle table and put in flat file in text format. Since exp and expdp data can only be read by imp and impdp, we only left with spool out using select * from format. Is there any other fast option available in Oracle to write to text file that can be readable by other databases?

Thanks
--Harvinder

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Wed Sep 29 2004 - 12:59:10 CDT