We have a very large database wich control a document approval workflow, filled by hundreds of forms, views and attachments.
We have noticed, by the fact of the size of the database affects considerably on performance, and wants to take an approach similar to mail archiving. Dispose old documents (not used in about 6 months?) in another database (archive one) but, to have te choice of restore this documents as soon as it is required by the application. (Today's authorization, depends on the comparative analisys of all the requirements made by a client, so, all his history must be revisited.)
Hopefully, this must be done transparent to the final user. This can be done? maybe using a third party app?
Please, any advice will be great. (sorry for my english)