none
Upgrade SSRS to 2012/2014 RRS feed

Answers

  • Hi,

    I have used Reporting Services Scripter in the past.

    Here is a step by step process.

    http://www.mssqltips.com/sqlservertip/2627/migrating-sql-reporting-services-to-a-new-server/

    Thanks,

    Sary


    Please mark as Answer if this answers your question ...Thanks, Sary Awwad

    Wednesday, February 4, 2015 5:02 PM
  • unfortunately you have more steps to do due to the technology changes, but Microsoft has provided some paths... The article below is pretty thorough.

    https://msdn.microsoft.com/en-us/library/ms143724.aspx

    Wednesday, February 4, 2015 8:23 PM
  • Hi S.Vijay Kumar,

    As per my understanding, you want to migrate a Reporting Services native mode deployment to a new SQL Server 2012/2014 Reporting Services instance. If that is the case, please refer to the following steps:

    1. Back up database, application, and configuration files.
    2. Back up the encryption key.
    3. Move the report server database and other application files from your SQL Server 2005 installation to your new SQL Server 2008 installation.
    4. Move any custom application files to the new installation.
    5. Configure the report server.
    6. Edit RSReportServer.config to include any custom settings from your previous installation.
    7. Optionally, configure custom Access Control Lists (ACLs) for the new Reporting Services Windows service group.
    8. Test your installation.
    9. Remove unused applications and tools after you have confirmed that the new instance is fully operational.

    For detail information about migrating a Reporting Services Installation, please refer to the following documents:
    https://msdn.microsoft.com/en-us/library/ms143724(v=sql.120).aspx

    If you want to update SSRS 2005 projects to SSRS 2012/2014, we can copy project files from report server 2005 to report server 2012/2014, the reports are automatically upgraded on first use. After you upgrade a report, you might notice additional errors, warnings, and messages. This is the result of changes to the internal report object model and processing components, which cause messages to appear when underlying problems in the report are detected.

    For detail information about upgrading Reports, please refer to the following document:
    https://technet.microsoft.com/en-us/library/ms143674(v=sql.120).aspx

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

    Thanks,
    Wendy Fu


    Wendy Fu
    TechNet Community Support


    Thursday, February 5, 2015 5:57 AM
    Moderator

All replies

  • Hi,

    I have used Reporting Services Scripter in the past.

    Here is a step by step process.

    http://www.mssqltips.com/sqlservertip/2627/migrating-sql-reporting-services-to-a-new-server/

    Thanks,

    Sary


    Please mark as Answer if this answers your question ...Thanks, Sary Awwad

    Wednesday, February 4, 2015 5:02 PM
  • unfortunately you have more steps to do due to the technology changes, but Microsoft has provided some paths... The article below is pretty thorough.

    https://msdn.microsoft.com/en-us/library/ms143724.aspx

    Wednesday, February 4, 2015 8:23 PM
  • Hi S.Vijay Kumar,

    As per my understanding, you want to migrate a Reporting Services native mode deployment to a new SQL Server 2012/2014 Reporting Services instance. If that is the case, please refer to the following steps:

    1. Back up database, application, and configuration files.
    2. Back up the encryption key.
    3. Move the report server database and other application files from your SQL Server 2005 installation to your new SQL Server 2008 installation.
    4. Move any custom application files to the new installation.
    5. Configure the report server.
    6. Edit RSReportServer.config to include any custom settings from your previous installation.
    7. Optionally, configure custom Access Control Lists (ACLs) for the new Reporting Services Windows service group.
    8. Test your installation.
    9. Remove unused applications and tools after you have confirmed that the new instance is fully operational.

    For detail information about migrating a Reporting Services Installation, please refer to the following documents:
    https://msdn.microsoft.com/en-us/library/ms143724(v=sql.120).aspx

    If you want to update SSRS 2005 projects to SSRS 2012/2014, we can copy project files from report server 2005 to report server 2012/2014, the reports are automatically upgraded on first use. After you upgrade a report, you might notice additional errors, warnings, and messages. This is the result of changes to the internal report object model and processing components, which cause messages to appear when underlying problems in the report are detected.

    For detail information about upgrading Reports, please refer to the following document:
    https://technet.microsoft.com/en-us/library/ms143674(v=sql.120).aspx

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

    Thanks,
    Wendy Fu


    Wendy Fu
    TechNet Community Support


    Thursday, February 5, 2015 5:57 AM
    Moderator