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 > <[email protected]>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 > > >
