Hello Martijn No, each Company is totally independent from the others.
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 <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
