Post reply

Upgrading/Moving Reporting DBs/Services from SQL 2008 to SQL 2014 (side by side)

  • October 14, 2015 at 6:14 am

    #312212

    Hi All,

    I have a requirement for a side by side upgrade of an instance from SQL 2008 to SQL 2014. There are reporting services configured. How to I properly migrate and configure the reporting piece on new SQL 2014 instance?

    Please advise.

    Many thanks in advance.

  • October 14, 2015 at 6:29 am

    #1833202

    This link should detail everything you need https://msdn.microsoft.com/en-us/library/ms143747(v=sql.120).aspx

  • October 14, 2015 at 8:12 am

    #1833250

    Thanks Anthony!

    https://msdn.microsoft.com/en-us/library/ms143724(v=sql.120).aspx

    Above article says we cannot rename reporting database name. Could you be able to shed some light on the following:

    *How to migrate the existing reporting database.?

    *On new instance can we drop the reporting dbs created by default after installation?

    *Does the new instance needs to be a named Instance?

    *How to re-configure reporting services?

    Thanks!

  • October 14, 2015 at 8:27 am

    #1833256

    So you want to change the SSRS database name from ReportServer at migration phase also?

    If so you will need to do some SOAP API calls to the 2008 SSRS box and 2014 SSRS box to transfer the catalog.

    If you want to keep the names the same, (IIRC) there are no breaking changes between 2008 and 2014, so restore the SSRS DB, install SSRS point SSRS to the restored DB, restore encryption key and it should work.

    Just make sure you do tests of your upgrade phases before actually doing anything for any hidden gotcha's

  • October 15, 2015 at 8:34 am

    #1833526

    Thanks. How to perform the migration using the default RS dbs on the new server.

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

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