Design A Process To Archive Data (sql Server 2005)

We're designing a process to archive a set of records based on different criteria like date, status, etc... Simplified set of tables: Claim, ClaimDetails, StatusHistory (tracks cha

Solution 1:

You can find some good discussion on this topic here and this is another one.

Having archived data in separate table gives more flexibility like if you want to track the user who marked a claim as archived or the date when a claim is archived or to see all the changes made to a claim after it is created.