Re: Data export from oracle 10G to SqlServer 2000

From: sybrandb <>
Date: 7 Aug 2006 05:50:58 -0700
Message-ID: <> wrote:
> Actually I did such work between two SqlServers but what I felt that it
> is more efficient to
> take data out from database in file and then insert that files on
> database.
> Rgrds

Any benchmarks to support this assertion? To me using flat files would typically be much slower, and more dangerous.
Disk volumes can fill up. This is one of the typical actions that would fill up a disk volume, especially if you don't clean up your 'temporary' files.

Sybrand Bakker
Senior Oracle DBA
Received on Mon Aug 07 2006 - 14:50:58 CEST

Original text of this message