none
Upgrading SSRS 2005 Reports to SSRS 2012 RRS feed

  • Question

  • Hi,

    Can we upgrade SSRS 2005 Reports to 2012 directly. Just deploying RDLs in Report server 2012 is enough or do we need to open and check in BIDS.
    Pl. help me on procedure how to Upgrade SSRS 2005 Reports to SSRS 2012

    Thanks,
    Bala

    Monday, January 14, 2013 4:32 PM

Answers

  • Hi Bala,

    When we upgrade a Reporting Services installation to a SQL Server 2012 Reporting Services (SSRS) installation, Report definition (.rdl) files are automatically upgraded in the following ways:

    1. The Report Server automatically upgrade existing published reports and report snapshots to the new report definition schema for the first time they are processed.
    2. When we open an .rdl file in Report Designer in Business Intelligence Development Studio (BI Dev Studio), if the report was created for a previous namespace, Report Designer automatically creates a backup file and upgrades the report to the current namespace. This is the only way we can upgrade a report definition file.

    Note: when we upload a report definition file directly to the Report Server or SharePoint site, the report are not upgraded. We should upgrade the .RDL file in Report Designer in Business Intelligence Development Studio (BI Dev Studio).
    For more information about upgrade reports, please see:
    http://msdn.microsoft.com/en-us/library/ms143674.aspx

    If you have any questions, please feel free to ask.

    Regards,
    Charlie Liao


    Charlie Liao
    TechNet Community Support

    Tuesday, January 15, 2013 5:32 AM
    Moderator

All replies

  • It should mostly just work. There may be some deprecated features between all of those releases and feature changes, but the report should still render even if it looks a little different. No need to open and redeploy with BIDS.

    Always follow standard backup procedures. http://technet.microsoft.com/en-us/library/bb522762(v=SQL.105)


    Brad Syputa, Microsoft Reporting Services This posting is provided "AS IS" with no warranties.

    Tuesday, January 15, 2013 12:46 AM
    Moderator
  • Hi Bala,

    When we upgrade a Reporting Services installation to a SQL Server 2012 Reporting Services (SSRS) installation, Report definition (.rdl) files are automatically upgraded in the following ways:

    1. The Report Server automatically upgrade existing published reports and report snapshots to the new report definition schema for the first time they are processed.
    2. When we open an .rdl file in Report Designer in Business Intelligence Development Studio (BI Dev Studio), if the report was created for a previous namespace, Report Designer automatically creates a backup file and upgrades the report to the current namespace. This is the only way we can upgrade a report definition file.

    Note: when we upload a report definition file directly to the Report Server or SharePoint site, the report are not upgraded. We should upgrade the .RDL file in Report Designer in Business Intelligence Development Studio (BI Dev Studio).
    For more information about upgrade reports, please see:
    http://msdn.microsoft.com/en-us/library/ms143674.aspx

    If you have any questions, please feel free to ask.

    Regards,
    Charlie Liao


    Charlie Liao
    TechNet Community Support

    Tuesday, January 15, 2013 5:32 AM
    Moderator