Thank you for your advice

Greetings.

Walter.

On Wed, Jan 18, 2012 at 7:56 AM, Martijn Tonies <m.tonies@...>wrote:

> **
>
>
> Hello Walter,
>
>
> > No, each Company is totally independent from the others.
>
> If there's no data whatsoever connecting these companies, no reports to be
> run on the aggregated data, I'd say from a safety point of view, separate
> each
> in a different database.
>
>
> With regards,
>
> Martijn Tonies
> Upscene Productions
> http://www.upscene.com
>
> Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
> Anywhere, MySQL, InterBase, NexusDB and Firebird!
>
> > Greetings.
> >
> > Walter.
> >
> >
> >
> > On Wed, Jan 18, 2012 at 6:29 AM, Martijn Tonies
> > <m.tonies@...>wrote:
> >
> >> **
>
> >>
> >>
> >> Hi,
> >>
> >>
> >> > I need to make an application that will be used by an accounting
> study.
> >> > They have too many clientes, so my question is:
> >> > - Is it better to have just one .FDB file and in each table add a
> >> > column
> >> > "Company Name"? or ...
> >> > - Is it better to have a .FDB file for each Company?
> >> >
> >> > If I have a .FDB file for each Company:
> >> > -------------------------------------------------------
> >> > - Data will be separated, no chance to unintentionally merge them
> >> > - The backup will be more complicated, because they will need to make
> >> 150,
> >> > 200, 300, or more backups
> >> > - It will be much more complicated to update the metadata, because
> they
> >> > will have 150, 200, 300 or more .FDB files
> >> >
> >> > So, somebody had passed for a similar situation? What's your advice?
> >>
> >> Do you require queries - for any purpose - to run across "companies"?
> >>
> >> If so, that settles it, unless you want to use the route of Stored
> >> Procedures
> >> with remote connections.
> >>
> >> With regards,
> >>
> >> Martijn Tonies
> >> Upscene Productions
> >> http://www.upscene.com
> >>
> >> Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
> >> Anywhere, MySQL, InterBase, NexusDB and Firebird!
> >>
> >>
> >>
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > ------------------------------------
>
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Visit http://www.firebirdsql.org and click the Resources item
> > on the main (top) menu. Try Knowledgebase and FAQ links !
> >
> > Also search the knowledgebases at http://www.ibphoenix.com
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > Yahoo! Groups Links
> >
> >
> >
>
>
>


[Non-text portions of this message have been removed]