Re: Data export from oracle 10G to SqlServer 2000
Date: 12 Aug 2006 22:27:29 -0700
Message-ID: <1155446849.609015.258570_at_i3g2000cwc.googlegroups.com>
No, Oracle Data Pump will not work since the output format is still
binary like in Oracle export.
In case amounts of data to be transfered not that large DTS will work
fine though.
wisdomforce fastreader could be a tool when there is a need to scale up with data size or increase speed
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.
Received on Sun Aug 13 2006 - 07:27:29 CEST