Article View: borland.public.interbase.replication
Article #210Re: How to determine if replication has completed
From: Brian Ellul
Date: Tue, 22 Apr 2003 16:31
Date: Tue, 22 Apr 2003 16:31
48 lines
2883 bytes
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-mailReferences:
<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