I follow the move of data (as I have a similar situation), but if there is considerable DRI involved, does this complicate the issue?
My situation is very similar in that I want to move the filegroups (monthly) from the primary data mart database to a data mart archive database (hence a different database name). The filegroups are 68 GB each (I have 36 of them) and the primary file group is 1.5 TB. I only wish to keep the primary and the most recent 3 months in the "active" data mart, whilst moving the remaining 33 file groups to the "archive" database, but there is so much referential integrity involved, it would be a nightmare.
Thanks!
Bob