Ernesto,

There are replication tools available from a couple of groups including
www.IBPhoenix.com


Sean

> -----Original Message-----
> From: firebird-support@yahoogroups.com [mailto:firebird-
> support@yahoogroups.com] On Behalf Of Ernesto Benestante
> Sent: Monday, September 22, 2008 5:19 PM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] online db synch
>
> 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.
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>