Transfer Of Data From Oraclegreenspun.com : 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
John,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.
Kothans.
-- Anonymous, June 27, 1999