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

I vote for DTS as the solution to this problem. For a M$ tool, it's not too shabby....

Brian

Paul Brewer wrote:
>
> "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

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"