Subject Archive expiriences
Author Planles

Could you share with we, what expiriences do you have with making archives
of some table data ?

Let me be more specific:
in an application with clients, orders, employee an similar stuf there can
be a few houndreeds or more orders each year.
Normaly we do not need to have all orders in actual orders table, but we
should be able to check any old order at any time.
So old orders should be transfered to another table with the same data
structure as actual one.

What approach do you prefer ?
Make just a new table within same database (fdb file) or is better and more
secure to create separate database (fdb file) just for archive.

I don't have in mind backing up my data, but exclude old orders from actual
orders table.