Subject | Updating remote DB |
---|---|
Author | Sudheer Palaparambil |
Post date | 2006-10-13T16:00:02Z |
Hi,
One of my client is using a firebird based billing application for their
retail outlets. They have around 80 outlets located at various parts of the
country. Now they want to set up a main database at their Head Office and
transfer all the data not summary. There are broadband connections available
at all the outlets but there are chances of internet connectivity going
down.
What I have in mind is to keep a thread for each table to write its
records into small packets and push it to a FTP space. And pull the same
from the server side and populate its tables. Our font-end application is
based on C++ with IBPP library. All outlets are using either embedded
firebird
or Superserver (outlets which has more than 1 system) on Windows XP. The
server at Head Office is Xeon Twin processor with 2GB RAM running RHEL 4
with
firebird Superserver.
Can this be succesfully implimented? Has anybody done a similar work
before?
Is there any other alternative? Please help.
Thank you.
Sudheer Palaparambil.
[Non-text portions of this message have been removed]
One of my client is using a firebird based billing application for their
retail outlets. They have around 80 outlets located at various parts of the
country. Now they want to set up a main database at their Head Office and
transfer all the data not summary. There are broadband connections available
at all the outlets but there are chances of internet connectivity going
down.
What I have in mind is to keep a thread for each table to write its
records into small packets and push it to a FTP space. And pull the same
from the server side and populate its tables. Our font-end application is
based on C++ with IBPP library. All outlets are using either embedded
firebird
or Superserver (outlets which has more than 1 system) on Windows XP. The
server at Head Office is Xeon Twin processor with 2GB RAM running RHEL 4
with
firebird Superserver.
Can this be succesfully implimented? Has anybody done a similar work
before?
Is there any other alternative? Please help.
Thank you.
Sudheer Palaparambil.
[Non-text portions of this message have been removed]