Migrate reports from SCCM 2007 to SCCM 2012

1. On you SCCM 2007 site server install either SCCM
   2007 R2 or SCCM 2007 R3, both will add SQL Reporting Services support for SCCM
   2007.

2. In the ConfigMgr. console,
   navigate to Site Database, Site Management, A01 (where A01 is
   the sitecode), Site Systems. Right click the Site system server
   that will become a Reporting Services Point and click New
   Roles. Select Reporting Services Point and finish the wizard using the
   default values.

3. In the ConfigMgr. console,
   navigate to Site Database, Computer Management, Reporting, Reporting
   Services, and expand the node.

4. Right-click SCCM1 (where SCCM1 is
   the name of your server), and then click Properties.

5. On the Data Source Settings tab,
   specify SCCM1 as the database server
   and SMS_A01as the database name (where SMS_A01 is the name of
   your SCCM 2007 database. ClickTest.

6. On the Data Source
   Authentication tab, select Windows integrated
   security.

7. Click OK.

Copy
reports to SQL Reporting Services

1. Right-click SCCM1, and
   select Copy Reports to Reporting Services.

2. On the Data Source Settings page,
   accept the default settings, and click Next.

3. On the Data Source Authentication
   page, accept the default settings, and click Next.

4. On the Select Reports page,
   accept the default settings, and click Next.

5. On the Security page, accept the
   default settings, and click Next.

6. On the Summary
   page, click Next.

7. On the Progress page – once all
   of the reports have copied – click Next and then
   clickClose.

Migrate
the SCCM 2007 reports to SCCM 2012
You
can’t use the built-in migration tools to migrate reports from SCCM 2007 to SCCM
2012. This leaves you with two choices; 1) Download each RDL file one by one
from SCCM 2007 and upload them to SCCM 2012 or 2) Use one of the free community
tools that can download multiple folders at the time. In my last project I used
this tool –
ReportSync – to assist me.

1. Launch ReportSync
2. In Source server type in the name of the SCCM 2007
   Report server in form of https://CM01/ReportServer. Provide credentials and
   click Load

3. In Destination server type in the name of the SCCM
   2012 Report server in form of https://CM02/ReportServer. Provide credentials and
   click Load
   

4. Select the folders or individual reports you want
   to migrate and click Sync
   

5. Once the process is finished
   click OK and your reports are now ready in SCCM 2012.

6. This tool keeps the old Data source which will
   generate an error the first time you run the report.
   

7. Open the report properties (by clicking on the
   report link)

8. Select Data Sources,
   click Browse and select the shared SCCM 2012 data source. The
   data source is found in HomeConfigMgr_Sitecode. The data source is the object
   with long GUID. Select the data source
   click OK and Apply.

9. Run the report and verify that it works. There is
   no guarantee the all SCCM 2007 reports work out of the box in SCCM 2012.
   

Download link
: https://code.google.com/p/reportsync/downloads/list

All credits goes
to Kent.