Re: Data export from oracle 10G to SqlServer 2000

aamir.majeed_at_gmail.com 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