A customer of mine wants to be able to archive/restore old historical data, audit logs, and alarm journals as needed. Ideally they would keep data less than 2 years old in the live database, and remove anything older than that. If they need to view old data for whatever reason, they want to be able to reimport the table or rows of a particular time period (similar to OSISoft PI data archives).
Typically I would set this data to prune after 2 years, but I don’t think this feature would play nice with any archive/restore strategy. Assuming I disable prune, it looks like i’m limited to custom SQL queries and scripts to regularly strip out/back up the old data (not ideal from a maintenance standpoint, among other reasons).
Has anyone done data archival in more simple/robust manner?