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: Brian Peasland <dba_at_nospam.peasland.net>
Date: Mon, 7 Aug 2006 13:36:48 GMT
Message-ID: <J3Mr5G.GEE@igsrsparc2.er.usgs.gov>


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

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown
Received on Mon Aug 07 2006 - 08:36:48 CDT

Original text of this message

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