Thank you for your advice Greetings.
Walter. On Wed, Jan 18, 2012 at 7:56 AM, Martijn Tonies <[email protected]>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 > > <[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 > > > > > > > > > [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/
