title: SQl Server How to maintain the data
body: <p>I am working on a product (ASP.NET Web site) developed for educational institutions. There are around 20 educational inst. in my site. For each of them academic year start and end date varies. There are huge number of records in the database for attendance and results.</p>
  
  <p>Now I need to show all previous years data (like attendance, results etc) whenever a student, teacher logs in. There are some reports which compares student performance in various academic years.</p>
  
  <p>Now my problem is how to maintain that huge data ?</p>
  
  <p>I wanted to go with 2 databases. 1 for current academic year, another for all previous yrs.</p>
  
  <p>But my current year DB schema may change for enhancement. So whenever I move the current year data to archive database then it creates problem for me. Please suggest a good way to implement this.</p>
  
  <p>Thanks,</p>
  
  <p>seshu.</p>