Reports Migration

  • We are using the sql serveSqr 2008r2. We have SSRS reports. We are migrating to Sql 2014. But the database is installed in different machine. We are planning to use the logshipping for migration.

    How to migrate the SSRS reports. Just backup the reportserver & encryption key is fine or do I need to consider any things?

  • You can do what you said in your last line, However I prefer using the migration tool. It will move the RDLs, shared data sets and sources to the new server.

  • What is that migration tool

  • ramana3327 (7/8/2015)


    What is that migration tool

    Google / Bing is my friend

    http://www.microsoft.com/en-us/download/details.aspx?id=29560

  • Thank you

  • Search for a tool called RSScripter.

    This will script your reports out for you and deploy them to the new server

  • Doesn't appear any links to RSScripter are valid any more.

    I'm guessing the Microsoft tool Blob_Eater linked us to is our only option?

    I'm migrating SSRS from a 2008R2 instance to 2014.

  • plaid_draco (6/29/2016)


    Doesn't appear any links to RSScripter are valid any more.

    I'm guessing the Microsoft tool Blob_Eater linked us to is our only option?

    I'm migrating SSRS from a 2008R2 instance to 2014.

    It does say :

    •Source and target server must be SQL Server Reporting Services 2008 R2 or later.

    I haven't tested it on 2014, but works ok with 2012.

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply