Requirement: Some data (basically a SELECT) FROM SQLServer(2K) to
Oracle/Lnux on a CONTINUAL basis.

Does NOT need to be Real-Time...can be like (Oracle's) Materialized View,
i.e. automagically refreshable.

What are my options in impleneting this process ?

thanks



--
10gR2/Linux

Hi

If you need to retrieve the data from the Oracle database from a session on
your SQL Server then the most obvious method would be a linked server. See
http://msdn.microsoft.com/library/de...qd_12_07s5.asp

http://msdn.microsoft.com/library/de...erver_4uuq.asp

another option would be to use replication from an Oracle publisher see
http://msdn2.microsoft.com/en-us/library/ms151859.aspx

John

"klabu" wrote:

> Requirement: Some data (basically a SELECT) FROM SQLServer(2K) to
> Oracle/Lnux on a CONTINUAL basis.
>
> Does NOT need to be Real-Time...can be like (Oracle's) Materialized View,
> i.e. automagically refreshable.
>
> What are my options in impleneting this process ?
>
> thanks
>
>
>
> --
> 10gR2/Linux
>
>
>

See reply in microsoft.public.sqlserver.server

"klabu" <noone_at_gmail_dot_com> wrote in message
news:12l9dtmi6jkv9f6@corp.supernews.com...
> Requirement: Some data (basically a SELECT) FROM SQLServer(2K) to
> Oracle/Lnux on a CONTINUAL basis.
>
> Does NOT need to be Real-Time...can be like (Oracle's) Materialized View,
> i.e. automagically refreshable.
>
> What are my options in impleneting this process ?
>
> thanks
>
>
>
> --
> 10gR2/Linux
>