> Hi, I have a software with a Firebird backend used by a customer and I
> need
> to allow a remote branch office to use it. The problem is that the
> network
> link is rather slow (for the needs of our software, at least): a VPN
> running over the Internet, ADSL access on both sides. The use of the
> software done on each site will be more or less complementary (but
> interdependant). The database is fully normalized, etc.
>
> After seeing that naively configuring everyone to access the same
> database
> online it will be much too slow for the remote users, I decided that
> each
> branch will have it's local server and respective database.
>
> So, the speed problem is solved, I need now to solve the
> synchronization
> problem just created... The pedestrian route would be to develop an
> had-oc
> two-way synchronization application but I'd prefer to avoid it, because
> the
> database frequently requires updates as the software evolves and I
> believe
> keeping boths apps in sync will be error prone.
>
> So to end the question is: Is there anything that could help me
> automate the
> database (re)synchronization problem? Continuous online resync would be
> a
> plus, but periodical batched updates would be Ok too.
>
> Thanks in advance,
> E.B.

www.ibphoenix.com has a list of replication tools available
Alan