locked
2005 to 2014 SSRS migration RRS feed

  • Question

  • Hi. I can't find a complete instructions on how to migrate SSRS from 2005 to 2014. Any ideas or information is greatly appreciated. Thank you.
    Friday, June 3, 2016 10:21 PM

Answers

  • Hi,

    We can refer to the following migration process:

    • Back up database, application, and configuration files.
    • Back up the encryption key.
    • Install a new instance of SQL Server 2014. If you are using the same hardware, you can install SQL Server 2014 side-by-side with your existing installation if it was one of the supported versions.
    • Move the report server database and other application files from your existing installation to your new SQL Server 2014 installation.
    • Move any custom application files to the new installation.
    • Configure the report server.
    • Edit RSReportServer.config to include any custom settings from your previous installation.

    For more information about Migrate a Reporting Services Installation:
    http://msdn.microsoft.com/en-us/library/ms143724.aspx

    Hope this helps.


    Please Dont forget to mark as answer and Helpful Post. It helps others to find relevant posts to the same question. Milan Das

    • Marked as answer by tirbanx Monday, June 6, 2016 7:54 PM
    Saturday, June 4, 2016 3:50 AM

All replies

  • Hi,

    We can refer to the following migration process:

    • Back up database, application, and configuration files.
    • Back up the encryption key.
    • Install a new instance of SQL Server 2014. If you are using the same hardware, you can install SQL Server 2014 side-by-side with your existing installation if it was one of the supported versions.
    • Move the report server database and other application files from your existing installation to your new SQL Server 2014 installation.
    • Move any custom application files to the new installation.
    • Configure the report server.
    • Edit RSReportServer.config to include any custom settings from your previous installation.

    For more information about Migrate a Reporting Services Installation:
    http://msdn.microsoft.com/en-us/library/ms143724.aspx

    Hope this helps.


    Please Dont forget to mark as answer and Helpful Post. It helps others to find relevant posts to the same question. Milan Das

    • Marked as answer by tirbanx Monday, June 6, 2016 7:54 PM
    Saturday, June 4, 2016 3:50 AM
  • I did it twice and both were succesfull

    Install and configure new SSRS 2014 server, copy a project solution (.rdl) to the new server and open it... It undergoes upgrade processes and you can use it safely .


    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Saturday, June 4, 2016 1:44 PM
  • Thank you.  I will try that.
    Monday, June 6, 2016 7:54 PM
  • Thank you!
    Monday, June 6, 2016 7:54 PM