On Thu, 11 Nov 2004 13:39:56 -0700, Ray Jenkins <reofax@...> wrote:

> Sorry hit reply to the other topic and forgot to change the subject
> line...
>
> I am starting to move all the in-house apps to Firbird. They have been
> running on Clipper and Paradox database systems.
>
> My question is this...
>
> How do I structure the new Database? Do I have one single fdb file and
> just throw all the tables in the same db, or do I split it out into
> some logical transaction based groupings? If I split it into multiple
> fdb files can they all reside in the same directory or should I
> seperate them into different subdirectories.

Can you give some points about applications and current databases.
But generally from my practice - I put all tables from all related in some
way systems in one Database. You get a lot of benefits with such
organization - JOINs in selects, FKs, simple administration.

Cheers,
--
Miroslav Penchev