Subject RE: [firebird-support] Single fdb or multiple fdb's
Author Thomas Steinmaurer

> 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.

They all can reside in one directory.

Be aware, if you split your tables into different
database files, then you won't be able to execute
a query over database boundaries in a single "pure"
SQL statement.

You also can't define a FOREIGN KEY constraint over
database boundaries.

Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions