Re: updateable snapshot

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Mon, 21 Apr 2003 00:02:55 +1000
Message-ID: <Ryxoa.18616$1s1.286510@newsfeeds.bigpond.com>

"Georg Scholz" <georg.scholz_at_vienna.at> wrote in message news:heroa.140168$UR.1247654_at_news.chello.at...
>
> This is NOT possible.
>
> Basically, a snapshot is the same as a view.
> The difference is that the snapshot is stored in a table, so when
accessing
> the snapshot, the data is promptly available and needs not to be
calculated.
>
> Think of the snapshot table as a "cache" which stores view data.
>
> When the master table is changed, the snapshot table will be refreshed
> (depending on your settings when creating the snapshot); but the other way
> round is impossible.
>

Hi Georg

This most certainly is possible.

To MC, look at the Replication API Reference manual where it has a nice example of how to set this all up (note you need to use Advanced Replication)

Cheers

Richard Received on Sun Apr 20 2003 - 09:02:55 CDT