It is equally important to design your datamodel so it is distributable.

A centralized datamodel does not generally scale to distributed without
attention to the issues of distribution.

I understand you problem - my first database application was for
construction site tracking. The communications tower generally went up
about 2 weeks after we left the site.

This is easier since you are using strong upstreaming, but you must
still pay attention to the datamodel.

On Mon, 2006-03-20 at 16:35 -0300, Alexandre Benson Smith wrote:
> killerion wrote:
> > I'm starting a new project with distributed servers, now my client
> > will be using aproximately 40-45 different databases, one central DB
> > with all the information in the main offices and then all the
> > suboffices will have their own DB with just the information
> pertaining
> > to its own local operation, I would have used just a single but the
> > local conditions don't permit that since some offices don't have
> > access to a permanent internet conection and will have to update the
> > main DB by phone, either directly or through the internet while
> others
> > do have access to broadband and will use the internet to update. Now
> > what Ineed to now is how feasible is this with firebird and any
> > suggestions on how to implement it...
> >
> Hi !
>
> Use replication.
>
> There is a number os different engines around.
>
> IBReplicator
> Copycat
> Replicador-br
>
> and so on....
>
> Some are commercial, others open source.
>
> see you !
>
> --
> Alexandre Benson Smith
> Development
> THOR Software e Comercial Ltda
> Santo Andre - Sao Paulo - Brazil
> www.thorsoftware.com.br
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
>
> SPONSORED LINKS
> Technical support
> Computer technical
> support
> Compaq computer
> technical support
> Compaq technical
> support
> Hewlett packard
> technical support
> Microsoft technical
> support
>
>
> ______________________________________________________________________
> YAHOO! GROUPS LINKS
>
> 1. Visit your group "firebird-support" on the web.
>
> 2. To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
> 3. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service.
>
>
> ______________________________________________________________________
>