Thanks Sudheer,

>
> 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.

Thanks a lot and warm regards

R. S. Patil