Re: Efficient comparison of two DBs

From: x <x_at_not-exists.org>
Date: Mon, 22 May 2006 18:18:55 +0300
Message-ID: <e4skk3$js4$1@emma.aioe.org>

"Bob Badour" <bbadour_at_pei.sympatico.ca> wrote in message news:Dhkcg.11441$A26.273777_at_ursa-nb00s0.nbnet.nb.ca...
> Ike wrote:
>
> > I am trying to discern what (an) algorithm might be, that would compare
two
> > databases which, at one time were mirror's of each other. That is, if at
one
> > point in the past, I had DB A, which was a mirror image of DB B, and A
has
> > not been touched, B has been in use. Now I want to compare the two, to
> > discern what records have been changed, added or deleted in B so that I
can
> > apply the same changes to A such that, when completed, A again mirrors
B.
> >
> > Does anyone have any thoughts on such an algorithm? Thanks, Ike

> Copy the log file over to A and roll forward.

But captain log was lost in a terrible accident. Anyone who give advise of this kind by Internet is a ... Received on Mon May 22 2006 - 10:18:55 CDT