Hi all
My customer has a CVP reporting server that contains huge data. Customer have been trying to get some reports over that database with some complex queries that some of them as view and some of the as stored procedure format. But as I said the data is huge and the queries are too complex so they have been not able to taken reports with those queries.

After all the effort they also tried to export those data to SQL 2005 server and then get reports over it but result was the same. So anyhow we like to make some consolidations on the source database tables and save them to another server during the data transition. This can be done manually but we would like to know if we can do this with archiver automatically or not.
 
Regards.