and I should have added : 5) If you still have a copy of the database from the old system, extract some of the historical data from that and insert it back into the table in option 4 above. Even more work, but avoids losing 5 months of history data.