Best Practices for Project Archiving (and Restoring)

I’m struggling to find my own strategy for archiving.

To maintain historical record and to easier refer to earlier projects, I desperately need to preserve creation and, ideally, modified dates. And, of course, archiving only by projects can make sense, not by individual actions. And from time to time I will likely need to i archive a project or two to continue working on it.

Emailed the support, but preserving dates when archiving is not in their foreseeable roadmap.

Has anyone tried to solve a similar puzzle? What is your approach?

My current plan is to be able find way to merge two databases which preserves dates. Given that, I could:

  1. Make first archive the following way:

    • make a copy of my active database
    • remove all active projects from that copy–this will give me an archive
    • remove all completed projects from my active database
  2. Unarchive a project the following way:

    • merge entire archive back into whole database
    • split the active database with the above process, but keeping the un-archived project in the active database
  3. Make subsequent archives as in 1., but every time to a separate archive database

Going to start trying this approach to merging: Manually merging two archives? [Yes, see thread]

Please share if you know a better approach.