SEO

#1 (**permalink**) 02-29-2008, 03:53 AM

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 ?

Thanks for your help

Cyril

#2 (**permalink**) 02-29-2008, 03:53 AM

"Cyril" <jewelk@free.fr> wrote in message
news:cd38c3d6.0408100617.6f7b9f3e@posting.google.c om...
> 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 ?
>
>
> Thanks for your help
>
> Cyril

Look into linked servers in Books Online - you can create a linked server
pointing to the Oracle database, then do this:

insert into dbo.MSSQLTable
select col1, col2, ...
from Oracle..SCHEMA.TABLE

Alternatively, DTS can move data from Oracle to MSSQL.

Simon

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

How to copy table from oracle database to sqlserver database ?