Transfer Of Data From Oracle : LUSENET : SQL Server Database Administration : One Thread

Hi, How will you transfer data from Oracle to SQL Server 6.5. Can I first create an export file from oracle and then run bcp to get the data to SQL Server 6.5. It is saild that that an export file is recognised only by Oracle Is it true. Does it make any difference if I run SQL 7 on Win NT or 95

-- Anonymous, June 26, 1999



With ORACLE SQLPlus write SQL Statement, use SPOOL Command to write your table data to the file (I spooled the data into the .txt file). Then bcp it into SQL Server.

Hope it helps.


-- Anonymous, June 27, 1999

Moderation questions? read the FAQ