Re: How to copy table from oracle database to sqlserver database ?

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Tue, 10 Aug 2004 20:54:28 +0100
Message-ID: <411927ed$0$20257$cc9e4d1f@news-text.dial.pipex.com>

"Cyril" <jewelk_at_free.fr> wrote in message news:cd38c3d6.0408100615.6371b40e_at_posting.google.com...
> Hello,
>
> I need to copy a table from an 8i oracle database to a sqlserver 2000
database.
>
> Is it possible to use the command "COPY FROM ... TO ..." ?
> So, what is the correct syntax ?

Do it from the sql server end using a graphical wizard (import data) and it is tremendously easy.

I have a step by step on setting up generic connectivity on my site if you wish to use sqlplus. For a one off job though I'd use sqlserver much much easier.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com

Received on Tue Aug 10 2004 - 14:54:28 CDT