Hi Alan,



I've looked at these some time ago, and what I found is below, please feel
free to point out if I've missed any as I really do need a quick solution.



FiBre



Still in development







Daffodil Replicator



Unsuitable for our needs







IBReplicator



Appears to work to an extent however when an error occurs there is no easy
way to determine where the error occurred. We have over 170 tables
replicated and process well in excess of 5 million transactions per day.
upto 50% of these occur during the first 2 hours (bulk file downloads) when
we find that IBReplicator simply cannot keep up to speed with the
requirements of the system. We have amended the triggers for the Large file
download tables to generate a Low_Priority generated number so that these
records drop down the sequence, however this still does not ease the issues
we have encountered.



If there are any others I've missed please feel free to bring these to our
attention we really do need a solution quickly.



Many Thanks



Andrew



_____

From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Alan McDonald
Sent: 27 October 2006 14:32
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] Replication Components - One to Many & Evaluation

> Hi Jason (and others)
>
> I am currently looking at developing a database replication program
> within Delphi 7 and connecting to a firebird database via IBObject
> components. We are looking to enable our clients to do the following.
>
> 1 Master Database Replicated in realTime into a number of Replicated
> Databases (initially 4)
>
> These replicated databases are for read access and only the master
> database is ever updated. We currently have load balancing and other
> setups inplace to ensure that this happens but we need to get the
> database replicating across.
>
> Firstly:
>
> Do the IBO_Replication Components allow one to Many One-way replication?
>
> and if so is it possible to obtain an evaluation copy of these
> components to test within our application?
>
>
> Many Thanks
>
> Andrew Alexander

by all means - write your own replication engine... but before you commit
this effort it would be worth looking at the free and commercial products
for replication. There are many - see www.ibphoenix.com for a full list. It
could save you a lot of time and effort.
Alan





[Non-text portions of this message have been removed]