Our client is planning to down size the database of their application. Currently there is 20 years of data and in production they want to keep only last 5 years data and rest will be archived.
I am little bit confuse about the testing strategy of this archiving and purging process.
Client is asking, how they will validate this archiving and purging process, so that it will ensure what ever data has been left as an active (last 5 years data), are accurate and there is no loss of data.
Thanks with Regards,