Migrate reports from SCCM 2007 to SCCM 2012 SP1

The built-in migration wizard in ConfigMgr 2012 can migrate most objects but not reports. In ConfigMgr 2012 classical ASP reports (as we know them from earlier versions) are no longer supported.

Migrate the classical reports to SQL Reporting Services in SCCM 2007

Below is a walk thru of how you migrate your existing classical reports to SQL reporting Services in SCCM 2007. Notice that you will still be able to run all classical reports after the migration.

  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_A01 as the database name (where SMS_A01 is the name of your SCCM 2007 database. Click Test.
  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 click Close.

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 http://CM01/ReportServer. Provide credentials and click Load
  3. In Destination server type in the name of the SCCM 2012 Report server in form of http://CM02/ReportServer. Provide credentials and click Load

    image

  4. Select the folders or individual reports you want to migrate.
  5. Select the Tools menu and click Map Datasources. Select the Destination data source, click Set and OK.

    image

  6. Click Sync
    image
  7. Once the process is finished click OK and your reports are now ready in SCCM 2012.
  8. 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.
    image

     


Comments (8):

  1. rachael says:

    Hi, I get error when i try to load the report web services URL, somthing like “the request failed with http status 404″

    Con you help me please

  2. rachael says:

    Hi, I get error when i try to load the report web services URL, somthing like “the request failed with http status 404″

    Can you help me please

  3. Rick says:

    to avoid this error. Copy the url to reports in Reporting Services configuration tool and paste in reportsync

  4. Wyatt says:

    Hi!!

    It is possible to use this tool when the report server of SCCM 2012 is configured with SSL?
    I’m not sure because I get the error “Loading Failed. The underlying conection was closed. Could not established relationship for the SSL/TLS sure channel” configuring the destination SSRS webservice with HTTPS (https://FQDNServerName/Reportserver.

    Thanks & regards

Leave a Reply

(required)