How to archive data is really under the purview of the database administrator, not FactorySQL. There are typically multiple different archiving strategies for each flavor of database. So, I’d have a meeting with your DB admin discussing how they want archiving to take place. If the archiving can be implemented as a stored procedure, you could easily automate the process using FactorySQL simply by calling the proc.
Here is an article that might get you started
vyaskn.tripod.com/sql_archive_data.htm