Dear Helen and Alan!
Thanks very much for Your info.

I will first get some more information as per Your suggestions and I will
try to undestand better all!

Regards!
Enrico

----- Original Message -----
From: "Alan McDonald" <alan@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, April 04, 2005 1:54 AM
Subject: RE: [IBO] Syncronize two databases


>
>> >Dear Group,
>> >I'm asking Your help about the sitatuion I will try to show You
>> very quickly:
>> >
>> >a) SERVER with a GLOBAL DATABASE.
>> >
>> >b) CLIENTS in other places with each one a PART of the GLOBAL DATABASE.
>> >(no connection to the GLOBAL DATABASE during the normal operation of the
>> >clients).
>> >
>> >c) Each clients has to be syncronized with the GLOBAL database
>> sending all
>> >the modified information on the clients and retrieving only the ones for
>> >the clients itself. Connection to be made for example one a day.
>> >
>> >Hope is clear. Any simple suggestion?
>>
>> Simple? No. The process you are describing is replication and it is not
>> simple.
>>
>>
>> >SYBASE has some particular routines that do this, but I'm
>> normally making
>> >my study tests with IBO.
>>
>> Sybase ships with a replication server. For Firebird and InterBase you
>> either purchase a replication product (such as IBReplicator) or you "roll
>> your own".
>>
>> There are some white papers by Vince Duggan (one of the original
>> authors of
>> IBReplicator) here, which will help you to understand the component parts
>> of a replication system:
>>
>> http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_replicator
>>
>> IBO has its own components for building a one-way replication
>> service. For
>> two-way replication, one would build two services - one to replicate
>> changes from your satellite databases to the global one and another to
>> collect all of the changes and replicate those back to the
>> satellites. There is on-line help describing the mechanics of this,
>> here:
>>
>> http://www.ibobjects.com/iborpl.html
>>
>> It's recommended that you really get your head around the issues involved
>> in building databases that can be synchronised, before you set
>> out to build
>> a replication service. Unique keys for tables, for example, are a major
>> issue...
>>
>> If Alan McDonald is watching, he will be able to direct you to another
>> replicator project - open source, I think - that he revived last year.
>>
>>
>> >I'm still using IBO 4.2Ie. (Not yer tried new version 4.5 Ai)
>>
>> I don't think IBO_RPL has changed since IBO 4.2.
>>
>> Helen
>
> yes - ibphoenix.com has a list of replication offerings. The one I
> revived
> provides for 2-way replication and will do what you are describing but the
> emphasis is correct here.. i.e. you need to study your design very closely
> before you commit to it such that replication will do as you expect.
> Alan
>
>
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
> papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>
>
>
>
>