Archiving data in K2 4.7 is available in K2 Workspace. In the event where it can take a long time to archive the data, you can use the attached scripts and the procedure described below to archive reporting data.
The script archives data from the K2 database to another user-specified database, and includes verbose logging and information about the data it is currently processing. The script sends the logging information to the SQL output window, showing which table is currently being processed, how many records are affected, their timestamps and when a section is complete. This logging is not configurable and is not saved -- it is live output data which gives you a better idea of how the archiving is progressing. This is helpful for first-time archiving as it can take a long time and might appear stalled.
Follow the steps below to create the necessary archive scripts and to execute the archive script.