Archive old records (?)

[H.P.]

Hi all,

Does anyone know an effective way to Archive old records in FM7 Server for Windows? For example, every year the admin can run a command to Archive all the previous year deleted/completed projects (records) onto another database and then achieve that database in some way to keep the current DB lean.

The reason why I need to implement this function is because I afraid after a few year, the database will become too big and might slow down the access speed signficantly. I use audit tracking intensively in the database also, so the db will grow in size very quickly.

Thanks!

Testinz.

[dkemme]

Archiving needs to be done by FM Pro. Create a clone of the database and then import each table into the clone of the data to be archived. After you are sure the clone is full of your archive data, go ahead and delete the data in the original database.

I used to do this, but have not noted any significant improvement in database speed so have stopped.