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 -> Re: Easiest way to transfer data from Oracle to SQL Server using a file.

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

From: James Williams <willjamu_at_mindspring.com>
Date: Fri, 20 Jun 2003 00:46:54 GMT
Message-ID: <3ef258dd.7049918@nntp.mindspring.com> 





On Tue, 17 Jun 2003 11:24:05 +0200, "Linus Nikander"
<linus_at_nikander.net> wrote:



Easier to me than DTS is to create a Linked Server in Enterprise
Manager using and Oracle or MS driver for Oracle.




Then you can say
 


insert into xxx


  select  * from xxxx1..scott.emp.




Wher xxxx1 is the linked server you created via EM or the SP_A* (SQL
has these crazy stored proc's!)  using the appropriate driver.
Received on Thu Jun 19 2003 - 19:46:54 CDT












Original text of this message













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