I was wandering what’s the eventstore’s story with data archiving. For example, say we were running eventstore for 4 years and now want to archive the events for the first year and keep the events for the last 3 years.
I was thinking about a migration tool which would pump the events with timestamps up to (now - 3 years) through a projection which would produce a snapshot for each stream with all of the remaining events appended on top (in a second eventstore instance). Then the application would be switched to the new eventstore instance.
Maybe the application could produce historical snapshots (as opposed to technical snapshots which would be produced more frequently) by itself and then trigger eventstore’s GC (I vaguely remember reading about something like $maxEventCount on stream metadata).
What would you recommend?