Re: Easiest way to transfer data from Oracle to SQL Server using a file.

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 17 Jun 2003 09:08:40 -0700
Message-ID: <92eeeff0.0306170808.2bbd1c78@posting.google.com>

"Linus Nikander" <linus_at_nikander.net> wrote in message news:<Y6BHa.38775$X2.822_at_news2.bredband.com>...
> Hi, what is the easiest way to transfer a table (including its data) from an
> Oracle installation (8.1.7) to an SQL Server 2000 one using a file ? I've
> been looking at using oracle's 'exp' utility to export data, but i can't
> seem to find any way for SQL Server to import it. Another way would be to
> export into a CSV file and then import that. All pointers appreciated.
>
> And yes, using a file is a must, I know that all this could be accomplished
> muche more easily using a db-> db connection but that simply isn't an
> option.
>
> //Linus Nikander - linus_at_nikander.net

Oracle "imp" tool can only read Oracle "exp" generated dump file so you can forget about that.

Just generate a delimited flat file... It's very trivial from sqlplus or other GUI tools. This is assuming Sql server can read a standard delimited flat file -:)

Regards
/Rauf Sarwar Received on Tue Jun 17 2003 - 11:08:40 CDT