How do I convert RDL v2005 and v2008 SSRS reports to RDL v2010 with C#?

See more:

C#

SQL

.NET

SSRS

C#5.0

Hello all-

My company just upgraded to SQL Server 2012 and the SSRS version which goes with it. We already migrated our reports, some of which are in SQL Server 2005 format, some of which are in SQL Server 2008/2008 R2 format, and some of which are in SQL Server 2012 format (the format we want).

We want to convert all the reports to be SQL Server 2012 format. So, how I am doing this is utilizing the MSReportBuilder tool (Microsoft SQL Server Report Builder) v3.0. What I am doing is, connecting to the SSRS server, then I am opening each report using the file > open dialog box, and then doing a file > save as into a different folder on the report server. This is a proven method, since MSReportBuilder automatically upgrades the RDL to be the most up-to-date schema version (RDL v2010) upon saving.

However, I am faced with having to do this for 300+ reports, and I feel like, if M$ can develop a tool to interface to report server correctly, so that it can save the report, then perhaps I can do the same with a quick LINQpad script.

I already know how to get the report XML from the ReportServer.Catalogs table in the db, but I don't know how to convert the XML to match the new schema like MSReportBuilder seems to know how to do.

I would like to script this up so I can run a for() loop over the reports to:

foreach(report in reports)
{
1. Load the existing report
2. Save/convert back to a new path
}

Any input/help? Thanks in advance!