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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Data export from oracle 10G to SqlServer 2000

Re: Data export from oracle 10G to SqlServer 2000

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 07 Aug 2006 06:58:23 -0700
Message-ID: <1154959099.14794@bubbleator.drizzle.com>


Brian Peasland wrote:
> aamir.majeed_at_gmail.com wrote:

>> I need to transfer data on daily basis from an oracle 10g database
>> running on Linux to the sql Server 2000 database.For that I need first
>> to get my query output from oracle into flat file and then bulkinsert
>> that file into sqlserver 2000.
>> I just read about Oracle Data Pump which could be used for Bulk Export
>> .I need to know how could I use data pump to get data out from oracle.
>>

>
> I'd use DTS for this operation. Write a DTS package to query the Oracle
> database through ODBC and pull the data into SQL Server....
>
> Cheers,
> Brian

I agree.

To the OP: But given ODBC there is nothing you can do in SQL Server that can't be done in Oracle without moving the data ... so what's the point of moving it? Why not just leave it where it is.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Mon Aug 07 2006 - 08:58:23 CDT

Original text of this message

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