Carl Nolan of the UK Solution Development Team wrote an excellent blog post on the above topic.  He includes a script for creating partitioned views that can be used if modifications to the existing activity items are continuing to be made.

http://blogs.msdn.com/b/mcsuksoldev/archive/2011/11/15/creating-a-partitioned-view-in-the-bam-archiving-database.aspx