MC wrote:
> "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?
>
> -- MC
Yes it is possible. Look up vertical partitioning in the
docu you are already reading.
Pay attention to the way the joins are to be constructed.
Only eqi-joins, and only via the PK columns.
--
Regards, Frank van Bortel
Received on Tue Apr 22 2003 - 11:30:21 CDT
