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

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Tue, 17 Jun 2003 20:24:36 +0100
Message-ID: <3eef6fd1_3@mk-nntp-1.news.uk.worldonline.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
>

Well, if a db -> db connection isn't an option (whyever not? Surely a simple DTS job would be enough):

Can the 'file' be an .mdb? If so, I might be tempted to attach tables in an M$Access db to the Oracle database, and then 'suck in' the M$Access tables to SQLServer. It's still going round the houses though, probably just to satisfy ill-considered client requirements.

Otherwise, csv is your man, as you and others have suggested. Easy enough from Oracle, as long as you are intelligent enough to cater for punctuation in text.

Regards,
Paul

By the way, please don't post to muliple C.D.O. groups Received on Tue Jun 17 2003 - 14:24:36 CDT