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

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: Fri, 20 Jun 2003 11:13:31 +0800
Message-ID: <1056078813.434749@cswreg.cos.agilent.com>

Oracle Hetrogneous Sevices that allows me to connect to SQL Server and Transfer Data.

http://otn.oracle.com/

Ensoy !!!

--
HTH

Regards,
Ganesh R


"James Williams" <willjamu_at_mindspring.com> wrote in message
news:3ef258dd.7049918_at_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 - 22:13:31 CDT