> Thanx for the info Anderson.. I will write just a small utility that
> would publish each stores stock onhand to the central server and have
> that run as a scheduled job say every hour or so..

Without reinventing the wheel, one could use an ETL tool like Kettle in
combination with the excellent Firebird JDBC driver to do that.


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/
50% DISCOUNT on all our LogManager products until Oct. 7th, 2008
HURRY UP: http://www.upscene.com/lm_party_promo.htm