hi all, i have a central db and different other external dbs on different machine connected with internet, all the machines have windows as SO.

all the dbs have some common tables.
i want to periodically take the common data from every external db and add them to the central db so i want know what's the best way to do that.

my ideal way is to use only the firebird service to have the specific data exported as a single file, than i send the file throw internet and update the db without using other external applications as db synchronization app.

note: in that tables i don't have primary key, trigger, or other problems so i can simply merge the rows of different source on the central db

thanks