I need to design a methodology maintaining only the current data (i.e.. for the last six months) in the active database, while maintaining a datawarehouse to store all data (from now back to the beginning of time) for reports that require historical data.

I`m sure there are many way to do this. I believe the answer will not be exclusively a SQL answer or exclusively a VB answer. It will be a complete design using front end and back end integration.

QUESTION: Can you recommend some source information KB, journals, web sites, books etc... regarding this topic?

Thanks!