Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Easiest way to transfer data from Oracle to SQL Server using a file.

Easiest way to transfer data from Oracle to SQL Server using a file.

From: Linus Nikander <linus_at_nikander.net>
Date: Tue, 17 Jun 2003 11:24:05 +0200
Message-ID: <Y6BHa.38775$X2.822@news2.bredband.com> 





Hi, what is the easiest way to transfer a table (including its data) from an
Oracle installation (8.1.7) to an SQL Server 2000 one using a file ? I've
been looking at using oracle's 'exp' utility to export data, but i can't
seem to find any way for SQL Server to import it. Another way would be to
export into a CSV file and then import that. All pointers appreciated.



And yes, using a file is a must, I know that all this could be accomplished
muche more easily using a db-> db connection but that simply isn't an
option.



//Linus Nikander - linus_at_nikander.net
Received on Tue Jun 17 2003 - 04:24:05 CDT












Original text of this message













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