Subject Re: [firebird-support] What's the best choice?
Author Martijn Tonies

> 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
with remote connections.

With regards,

Martijn Tonies
Upscene Productions

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!