Subject | Question about Database Design, for a multi-enterprise database ( newbie ) |
---|---|
Author | joaquimmacedo |
Post date | 2010-03-26T17:23:06Z |
Hi all!
I'm new to Firebird and I've just downloaded Firebird 2.1.3 and installed it as Super Server on a Windows Vista computer.
I want to create a software application ( in Delphi ), using Firebird.
This application will be multi-enterprise ( ie, it can manage different enterprises ).
What I would like to ask, is - what is the best approach:
to create a database field, in all tables, that represents the Enterprise Code
OR
access different database files ( with the same tables ) - one for each Enterprise - from the software application?
Thanks a lot in advance.
Best regards,
Joaquim.
I'm new to Firebird and I've just downloaded Firebird 2.1.3 and installed it as Super Server on a Windows Vista computer.
I want to create a software application ( in Delphi ), using Firebird.
This application will be multi-enterprise ( ie, it can manage different enterprises ).
What I would like to ask, is - what is the best approach:
to create a database field, in all tables, that represents the Enterprise Code
OR
access different database files ( with the same tables ) - one for each Enterprise - from the software application?
Thanks a lot in advance.
Best regards,
Joaquim.