Whats the best way to save records in alternative DB

[Deon]

I have a stock db with records that go back to 2006. I want to clear some of the old records but save them incase required. I still need to leave from 2010 until present on the db. I have a front and back end on the db.
Any help appreciated.

 

[Shado]

Put a bit datatype'd field that decides if the records old or new? What technology are you moving the backend to? SQL Server?