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.