trying to mirror a db
From: Ike <rxv_at_hotmail.com>
Date: Mon, 03 Apr 2006 14:55:51 GMT
Message-ID: <XHaYf.13250$sL2.754_at_newsread2.news.atl.earthlink.net>
If I have two databases, A and B, each with only one table, and the tables are supposed to miror each other (yet, B gets interacted with independent of A, and vice versa) and the table in A has a field for the timestamp of last activity for each record, as well as a field for the corresponing id of each record in B that the record in A corresponds to.
Date: Mon, 03 Apr 2006 14:55:51 GMT
Message-ID: <XHaYf.13250$sL2.754_at_newsread2.news.atl.earthlink.net>
If I have two databases, A and B, each with only one table, and the tables are supposed to miror each other (yet, B gets interacted with independent of A, and vice versa) and the table in A has a field for the timestamp of last activity for each record, as well as a field for the corresponing id of each record in B that the record in A corresponds to.
I am trying to discern an alogirthm for maintining these two tables to be concurrent with each other. Does anyone have any ideas, given the description above for an algorithm to do this?
Thanks, Ike Received on Mon Apr 03 2006 - 16:55:51 CEST