I have a constantly developing application and i want to archive its DB. The DB tables structures constantly change. My idea is to develop non changing core structures (tables) of production tables. It will be something like physical DataMart. For example if I have client information in Application DB, in DataMart I will have only information that exists in any release of Application DB (Name, Surname, Birthday etc).
Then I will populate this DataMart with data from Application DB. Then I will archive DataMart and I will do it for each release of Application DB. As a result I will have same structures in the archives for all releases. Is there any more effective ways to accomplish these tasks? Does anybody have relative experience? What products would you suggest to use (any budget)? Thanks!