Oracle provides a free migration utility to go between Oracle and SQL
Server (among others).
http://otn.oracle.com/tech/migration/workbench/content.html
Never tried it, though.
I would imagine there are certain datatypes that can't be migrated but
don't know for sure.
"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
Received on Wed Jun 18 2003 - 19:33:19 CDT
