Re: detect changes on a table

From: Hans Forbrich <news.hans_at_telus.net>
Date: Mon, 27 Sep 2004 13:57:29 GMT
Message-ID: <d%U5d.121566$KU5.14186@edtnps89>

Artturi wrote:

> Hans Forbrich wrote:
> 
>> Artturi wrote:
>> 

>>> Hello,
>>>
>>> I have to create a database (A) based on the content of another one (B,
>>> hosted on oracle) which hosts informations on students (and driven by a
>>> commercial application).
>>> If it will be simple to populate db A initially, I don't see a way to
>>> keep the data in sync with B as updates will occur.
>>>
>>> Do someone here have an idea about that ?
>>> Is there a way to detect updated records for a given table ?
>>>
>>> Thanks in advance,

>> 
>> What version of database(s)?  What access do you have to the data in B?
> 
> Db B's version is oracle 8.1.7. I think I'll have only read access to the
> data in B but this may be negotiated.
> Db A would be MS Sql Server or MySQL
> 
> Thanks for your answers, I will have a look at it.

Streams and Advanced Replication will not work nicely in a heterogeneous (non-Oracle) environment. You may want to look at Oracle's Heterogeneous Services, Triggers and Materialized Views (aka replication Snapshots).

A homogeneous environment, at least for staging the data, would be much easier.

Sigh - that's what I get for answering without the full facts. Received on Mon Sep 27 2004 - 08:57:29 CDT