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
>
>
>