Re: detect changes on a table

From: Artturi <artturi.nospam_at_free.fr>
Date: Mon, 27 Sep 2004 10:12:12 +0200
Message-Id: <4157caf5$0$27298$626a14ce@news.free.fr>

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.

-- 
Artturi

Received on Mon Sep 27 2004 - 03:12:12 CDT