Archive and purge

FTM does not currently implement archive functionality but it does provide a purge utility.

However, you can use standard database replication techniques to implement an archive, where the archive is a secondary FTM database that uses either the full or a partial schema. The replicated copy can be configured to ignore DELETE operations and replicate only INSERT and UPDATE operations. If a partial schema is implemented, the replicated copy can ignore operations that relate to omitted tables.

The following topics provide general information about purge and archive. They also provide installation and usage instructions for the purge utility that is supplied with FTM.