🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

IBReplicator API

#14
From: John Reynolds
Date: Thu, 04 Mar 2004 21:35
25 lines
1881 bytes
Hi,
 Is there a way to control the IBReplicator via a Delphi app ? I have
IB 7.1 and Delphi 7. I've searched around but came up empty.

 I have a DB app that requires archiving the .GDB file at the end of
the month. The archive DB must still be online. The steps involved are:
	1) Stop adding data to the current DB.
	2) Wait until the REPL_LOG table is empty, signifying all data has
		 been replicated.
	3) Stop the Repl service.
	4) Copy the current DB, giving it an archive name.
	5) Empty the data table in the current DB.

	The Repl service is setup to run every 15 mins. I would like
to change this to 1 sec, restart the Repl service, then wait until
the REPL_LOG empties, then set the back to 15 mins. I can start and
stop IBREPL using the NT API but don't know how to reconfigure the
Repl params programmatically . Where does IBRepl store its Interval value ?
I've monitored the IBReplService.exe file and registry access while
starting, but can't find where it's getting it.
 Is there an easier way to do this ?


	Thanks for any input,
	John
Technical Details
Message-ID: <d31046c9.0403041335.7dee4121@posting.google.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f89d7,a0fd325da80f56ba,start
X-Google-Attributes: gidf89d7,public
X-Google-ArrivalTime: 2004-03-04 13:35:42 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail
From: jjreynolds2004@yahoo.com (John Reynolds)
Newsgroups: borland.public.interbase.replication
Subject: IBReplicator API
Date: 4 Mar 2004 13:35:41 -0800
Organization: http://groups.google.com
Lines: 25
Message-ID: <d31046c9.0403041335.7dee4121@posting.google.com>
NNTP-Posting-Host: 208.177.34.219
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1078436141 17546 127.0.0.1 (4 Mar 2004 21:35:41 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 4 Mar 2004 21:35:41 +0000 (UTC)