Database Splitting

Hi,

I would like to know if we can split the company database according to posting periods. One of my clients doesn't want to keep more than two years of data visible. He wants to split the database and store the older transactions separately. This is possible in some of the other applications e.g. Tally accounting software (India). How can we achieve this through SAP B1? Or can we do it through SQL?

Thanks,

Amol.