>>>>>>What would be the best way to make a software multi-companies. I use Stonefield Database Toolkit. Would SDT make things easier?
>>>>>>
>>>>>>Overall Feedback?
>>>>>
>>>>>Hi Denis,
>>>>>
>>>>>I definitely would recommend SDT. I have a vertical market application used by many different companies. And I use SDT in such way that even though the database is the same, different tables can have custom fields (additional fields) without me having to customize the application.
>>>>
>>>>Hi Dmitry,
>>>>
>>>>Yes it could be a way to do it but what about creating multiple databases. 1 database per company. How could SDT manage this? Would it be able to still to manage this with the updates and everything?
>>>>
>>>>By the way I created another thread in the Stonefield category. You can also reply there if you want. I thought creating it in that category would be better suited for my problem.
>>>>
>>>>Thanks
>>>
>>>From Sergey's message I presume that he is not much in favor of putting records of multiple companies into the same tables. And I thought of another approach you might want to consider. Probably much more involved but still an alternative. You could have a suffix number added to the database container and all tables for each company "database". E.g. Database01.d??, TableA01.dbf, Table01, Database02.d?? and so on. Then whenever you open a database or a table you would need to have the code to use the name with the appropriate company suffix.
>>>
>>>HTH.
>>
>>
>>That's a nightmare you're proposing.
>>Best is a company Id in the tables.
>>
>>Next best is one db per company
>
>What I was proposing is also one db per company, just using a certain naming convention.

As long as each company has its own database. Unless the companies are tied together in some way (same parent company for example and management will want reports that cover all companies (sales to a customer across any company, supplies bought from a vendor across any company, profit from a single product across any company, etc.), each should have its own database. General practice is to have one database per balance sheet or tax ID. Will the companies pay for specific security, hardware, or backup/replication? Do the companies have different auditing and/or data storage requirements? It really all depends on the type of app and the type of customers...