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

From: Palooka <>
Date: Tue, 12 Aug 2008 23:25:44 +0100
Message-ID: <F5ook.34569$rv6.17565@newsfe12.ams2> 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!

I don't know the answer to the second question, nor your versions, but the first should be straightforward enough. Set up an ODBC connection to the Oracle database and create a DTS job.

Palooka Received on Tue Aug 12 2008 - 17:25:44 CDT

Original text of this message