@Lian

Certainly true, but hopefully less and less. We (briefly) considered reverse engineering the SQL 2008 MDW / data collector solution to gather data from SQL 2005 instances, but...

I could, but would direct you to Bill's blog first:

http://blogs.msdn.com/b/billramo/

There's a six part series there on migrating MDW reports to SSRS. Bill's approach leverages a new query data...

Have you considered using the Management Data Warehouse feature available natively in SQL 2008 and higher?

http://msdn.microsoft.com/en-us/library/dd939169(v=SQL.100).aspx

We've found it to be quite useful for performance diagnostics, without the need...