Re: updateable snapshot

From: MC <manikroy_bd_at_yahoo.com>
Date: 20 Apr 2003 22:52:40 -0700
Message-ID: <648c5dd4.0304202152.19284ab0@posting.google.com>

"Richard Foote" <richard.foote_at_bigpond.com> wrote in message news:<Ryxoa.18616$1s1.286510_at_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.

> 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

Hi Richard,

Thanks, I am reading the doc.

By the by, do you think it is possible to make *a* snapshot of multiple master tables data into only **one** table? It is like that multiple master sites have same table structure with different primary keys and data and those tables data will be replicated into *one* table at a snapshot site. Is it possible with Advanced Replication API? Or is it better do with SELECT and INSERT?

Received on Mon Apr 21 2003 - 00:52:40 CDT