"Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message news:<411927ed$0$20257$cc9e4d1f_at_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.
Try unload Oracle tables into text flat file with WisdomForce
FastReader (www.wisdomforce.com). FastReader generates control files
for mssql loaders as well automatically.
Received on Sat Aug 28 2004 - 17:40:34 CDT
