MS SQL Data Warehousing - Some Data from SS2000 to Oracle : Options ?

Author

Some Data from SS2000 to Oracle : Options ?

klabu

2006-11-10, 7:14 pm

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

John Bell

2006-11-10, 7:14 pm

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/d..._qd_12_07s5.asp

http://msdn.microsoft.com/library/d...server_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
>
>
>

John Bell

2006-11-12, 5:14 am

See reply in microsoft.public.sqlserver.server

"klabu" < noone_at_gmail_dot_c
om> 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
>

Sponsored Links