🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.interbase.replication
Article #210

Re: How to determine if replication has completed

#210
From: Brian Ellul
Date: Tue, 22 Apr 2003 16:31
48 lines
2883 bytes
"Roger Fried" <rogerfcom@yahoo.com> wrote in message
news:3ea56169$1@newsgroups.borland.com...
>
>
> Wouldn't that require another call to each location (via RAS)?
No. In your case you'll just need to enquire the source database. If the
repl_log table of the source database is empty, this means that the changes
have been replicated over.

>Is there a way without making another call?
I don't know. My company just bought the replication licences two months ago
and I'm still experimenting and checking how this software works. Try
sending an email to Vince maybe (most probably not) he'll guide you on this
one.

>Also, what would one look for in the repl_log to determine that replication
had finished?
The repl_log table is found in all databases participating in the
replication scheme. It basically logs all changes made in the particular
database and once the replication process is triggered, the replication
process would scan the repl_log table, send the changes over to the other
databases and once done delete the rows which have been replicated.

Regards
Brian

>
>
> "Brian Ellul" <brianellul@ecenglish.com> wrote:
> >By checking the replication logging table - REPL_LOG in both the source &
> >target databases. All database changes are logged in this table.
> >
> >Brian
> >
> >"Roger Fried" <rogerfcom@yahoo.com> wrote in message
> >news:3ea43493$1@newsgroups.borland.com...
> >>
> >>
> >> I am using IBReplicator with Interbase 7 to replicate data among
several
> >locations.  I need to be able to detect that a replication has completed
so
> >that I can run some procedures on the resulting data, after which I will
> >trigger another replication to give all locations the updated data.  The
> >question is, how can I know that the first replication has completed?
> >
> >
>
Technical Details
Message-ID: <3ea56f40@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-01!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail
References: <3ea43493$1@newsgroups.borland.com> <3ea4e5f7$1@newsgroups.borland.com> <3ea56169$1@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f89d7,f6d49d5a3db8e152
X-Google-Attributes: gidf89d7,public
X-Google-ArrivalTime: 2003-04-22 09:39:59 PST
From: "Brian Ellul" <brianellul@ecenglish.com>
Newsgroups: borland.public.interbase.replication
References: <3ea43493$1@newsgroups.borland.com> <3ea4e5f7$1@newsgroups.borland.com> <3ea56169$1@newsgroups.borland.com>
Subject: Re: How to determine if replication has completed
Date: Tue, 22 Apr 2003 18:31:19 +0200
Lines: 50
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 62.173.4.213
Message-ID: <3ea56f40@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1051029312 62.173.4.213 (22 Apr 2003 09:35:12 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-01!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail