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_at_bubbleator.drizzle.com>
>
> 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
Date: Mon, 07 Aug 2006 06:58:23 -0700
Message-ID: <1154959099.14794_at_bubbleator.drizzle.com>
Brian Peasland wrote:
> aamir.majeed_at_gmail.com wrote:
[Quoted] >> 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.orgReceived on Mon Aug 07 2006 - 15:58:23 CEST