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!
