| Shuchit 2005-11-02, 7:23 am |
| vsv <nospam@nospam.com> wrote in news:43681f50$1@foru
ms-1-dub:
> Requirement:
> I want to obtain the list of all records that are being downloaded
> (update/insert) into a table & process those records to populate other
> table in remote only.
>
> env: asa 9.0.2.2451 remote db
> ase 12.5.1 consolidated
>
> I am trying to accomplish this using the last download time.
I usually do not use the last download time to accomplish this. Remember that
timestamp is from a different system which could be in a different timezone,
or the clocks on the remote and consolidated might not be sync.
I would usually add an indicator column to the table. It should only be on
the remote.
You can either make it part of the publication (so that it will be
included in the download stream); or you can play with triggers that can
figure out they were fired due to dbmlsync and achieve the same effect.
On each download, set the indicator column to a specific value (say
'updated'). After the synchronization, you can just process every row that
has indicator value ='updated' and once you are done processing update the
indicator to 'processed'.
hth,
Shuchit
|