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

From: DA Morgan <>
Date: Tue, 12 Aug 2008 17:26:24 -0700
Message-ID: <> 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 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 (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Tue Aug 12 2008 - 19:26:24 CDT

Original text of this message