Re: Oracle DB to MS Sql Server DB Replication question...via Sql Server Views??

doemon_at_gmail.com wrote:
> Hi,
>
> I'm not sure if this is even possible, but I've been asked to look
> into replication from Oracle to Sql Server. He's the situation:
> We have access to a remote Oracle database, but only read access (not
> allowed to configure or change the db).
> We own a Sql Server database with Views that use a link server to
> query the Oracle database.
>
> With this setup, is it possible to replicate the Oracle database? Can
> we do a replication from the Sql Server with the Views into another
> Sql Server database, and if we can, will it be able to only pull the
> delta for subsequent replications?
>
> Any tips and hints would be helpful. Pleeease!
>
> Thanx,
>
> Doemon

Go to http://otn.oracle.com and download a copy, free, of Application Express. It will seamlessly run circles around what you are proposing.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org