469,325 Members | 1,404 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,325 developers. It's quick & easy.

How to copy table from oracle database to sqlserver database ?

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
Jul 20 '05 #1
1 4055

"Cyril" <je****@free.fr> wrote in message
news:cd**************************@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

Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Santo Santis | last post: by
4 posts views Thread by PC Datasheet | last post: by
2 posts views Thread by =?Utf-8?B?SmVmZnJleQ==?= | last post: by
1 post views Thread by dario.8282 | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by Gurmeet2796 | last post: by
reply views Thread by mdpf | last post: by
reply views Thread by harlem98 | last post: by
reply views Thread by listenups61195 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.