>> Pls have a look at the open source project
>> http://symmetricds.codehaus.org/ for synchronization. I have been using this
>> for the last 2 years
>> with Firebird database. This works fantastically. You can sync both ways, HO
>> to branch as well as branch to HO.
>>
>
> Yet another option for me. I visited the link you mentioned and I am impressed with general Description. The idea of two tier replication is simply fantastic. Since you are using it for last two years can you give us general idea about it ? like how configuration is done, how is response time (since its in Java), Can it function with Delphi application ? etc. etc. Please also mention any problems you faced may be initially and resolved later.

I'm not using it, but interesting products. Check out Firebird-specific
information here:
http://symmetricds.codehaus.org/guide/2.4/html-single/user-guide.html#ap02-firebird


A mandatory UDF library and limiting BLOB columns to 16K might be
show-stoppers.


--
With regards,
Thomas Steinmaurer

* Upscene Productions - Database Tools for Developers
http://www.upscene.com/

* My Blog
http://blog.upscene.com/thomas/index.php

* Firebird Foundation Committee Member
http://www.firebirdsql.org/en/firebird-foundation/