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

On 10 Aug 2004, jewelk_at_free.fr wrote:
> Hello,
>
> I need to copy a table from an 8i oracle database to a
> sqlserver 2000 database.

A few options exist. If this is one-off, just use sqlldr to drop the data to a file and then bcp to get it into SQLServer.

> Is it possible to use the command "COPY FROM ... TO ..." ?
> So, what is the correct syntax ?

Well, I'm sure SQLServer has connectivity to Oracle? If you want to go this route, use that and do this from SQLServer.

-- 
Galen Boyer