none
migrate ssrs 2005 to 2012

    Question

  • Hi there,

    I have around 100 reports in SQL sever 2005 and plan to migrate them to SQL Server 2012.

    Can I simply deploy my data sources and rdl's of sql server 2005 in Sql 2012 ssrs server. Would i face some compatible issue with 2005 rdl in 2012 environment.

    TIA!!

    Sunday, September 30, 2012 10:21 AM

Answers

  • Hi Ricky,

    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

    When there are references to custom code embedded in a report or to custom assemblies, reports might require additional steps to complete the upgrade during an upgrade of a report server. Custom assemblies should be moved manually to the new installation folder if we want to continue using the custom functionality in reports. If these assemblies are installed in the report server installation folder, they need to be moved to the new installation folder after the upgrade completes.
    For more information about upgrade advisor to prepare for upgrades, please see:
    http://msdn.microsoft.com/en-us/library/ms144256.aspx

    Regards,
    Fanny Liu


    Fanny Liu

    TechNet Community Support

    Friday, October 05, 2012 6:15 AM

All replies

  • Hi Ricky,

    Generally if  you deploy  SSRS 2005 report to SSRS 2012 report manager they work fine , but in some case they may not work, for example if you are using any custom code inside your report.

    Since in you case number of reports is pretty high, you might want to some preassessment pre migration and end to end testing after the post migration.

    For complete migration you can follow this link - > http://msdn.microsoft.com/en-us/library/ms143747.aspx


    Regards Harsh

    Sunday, September 30, 2012 3:32 PM
  • Thats encouraging, report does have some custom code, but they are very simple, nothing fancy function and i guess 2012 should support vb script codes as were in2005. does it?

    TIA

    Monday, October 01, 2012 6:39 AM
  • Hi Ricky,

    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

    When there are references to custom code embedded in a report or to custom assemblies, reports might require additional steps to complete the upgrade during an upgrade of a report server. Custom assemblies should be moved manually to the new installation folder if we want to continue using the custom functionality in reports. If these assemblies are installed in the report server installation folder, they need to be moved to the new installation folder after the upgrade completes.
    For more information about upgrade advisor to prepare for upgrades, please see:
    http://msdn.microsoft.com/en-us/library/ms144256.aspx

    Regards,
    Fanny Liu


    Fanny Liu

    TechNet Community Support

    Friday, October 05, 2012 6:15 AM
  • Thanks Guys for Info

    Here are few other options

    Was exploring easiest way to Migrate SSRS 2005 to SSRS 2012 and found below tool:

    https://code.google.com/p/reportsync/

    http://basitaalishan.com/2013/04/02/sql-server-reporiting-services-migrating-ssrs-reports-data-sources-and-subscriptions-from-one-server-to-another/

    This tool will allow you to download all the RDLs and Data Sources from 2005 Server and Upload those to 2012 Reporting server.

    There is a synchronize option and I think this will allow you to synchronize both the servers and will move all the stuffs like Subscriptions and Security and others. I have not tested Syncro option available in this tool so In case your subscriptions are not moved then You may create those manually on new 2012 Servers one by one.

     Note: This way we are just migrating Reporting Server and not the Report RDLs (Still Our RDLs are in 2005 Version).

    To Upgrade RDLs, Open all 2005 RDLs in 2012 BIDS and It will automatically Upgrade it to 2012 and then you can deploy complete project to your Report Manager Server from BIDS.

    http://www.cognitiveinfo.com/2012/syncronize-report-servers/

    http://www.sqlcircuit.com/2012/11/ssrs-different-ways-of-deploying-reports.html

    Note: It is not the best Practice to simply restore Reporting DB from 2005 to 2012 because I have noticed the Schema and columns level changes in Reporting DB 2005 and 2012.

    From 2008 to 2012 Here we have another tool: http://www.microsoft.com/en-us/download/details.aspx?id=29560


    Thanks Shiven:) If Answer is Helpful, Please Vote




    Thursday, June 13, 2013 5:45 AM