471,887 Members | 1,438 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,887 software developers and data experts.

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 4167

"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
reply views Thread by YellowAndGreen | last post: by
reply views Thread by zermasroor | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.