> I would like to develop this app into web based app where users (from
> different parts of the world) can setup source and destination
> databases' path by the way of IP addresses and merge them accordingly
> to a central location.

You should keep in mind that there are three things that are likely to stand
in your path of success with this - firewalls, system administrators and
speed.

Firstly by default, Firebird serves on port 3050 which is almost NEVER
opened up on a Firewall for any server that is exposed to the Internet.
Most system administrators are going to really give you a hard time to open
up such a port as they are trying to restrict just what is accessible to the
outside world. You'll have to find a very good and secure reason for them
to do this and feel comfortable with it. Just keep in mind that any server
exposed to the Internet is a security risk, and the biggest headache to a
system administrator. The firewall is one way that they can keep threats at
bay, or at least defined to known ports. So you'll need a strategy for how
to allow FB to be accessible to the outside world in regards to ports.

Secondly, if you have ever attempted to do database synchronization over a
WAN, particularly between countries, you'll realize that the speed of the
Internet for this can be very slow and often will be faced with recovering
from drop outs, etc. Firebird is incredibly fast on a local server, and on
a LAN, but like any database that runs over a Wide Area Network, its going
to be brought down to the lowest common denominator for speed. There are a
number of tools out there that help with this, but don't expect fast
performance for doing large amounts of data merging this way.

It would probably be a better idea to FTP a file containing the data you
want to merge to the server where the FB database is on, and then executing
a procedure on that server to load the data than to try and pass it, row by
row, over a WAN from DB to DB.

Regards,
Myles

===============================
Myles Wakeham
Director of Engineering
Tech Solutions US, Inc.
Phone (480) 451-7440
www.techsol.org