Sync SSRS report between two report servers:


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_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 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
    ka021301.jpg

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

  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.
    ka021303.jpg

  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.
    ka021305.jpg

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

All credits goes
to Kent.

 

Leave a Reply

Your email address will not be published. Required fields are marked *