locked
Migrate Reporting Services Point SCCM 2012 to new server RRS feed

  • Question

  • How do I move the reporting services point?

    José Anderson Santiago Microsoft Community Contributor - MCP - MCDST - MCSA - MCTS - MCITP - MCT / Se a resposta foi útil classifique.

    Friday, June 21, 2013 8:40 PM

Answers

  • There is only 1 way to do this.. Create a new RP and remove the old one.. But keep in mind that this will NOT move any custom reports. You will need to backup the RDL and move them to the new server.

    http://www.enhansoft.com/

    • Marked as answer by JOSE ANDERSON Monday, June 24, 2013 2:17 AM
    Saturday, June 22, 2013 1:02 AM
  • Why would it be?

    The reporting DB only contain information about reporting specific things like the reports and subscriptions. The data displayed in the reports is always pulled from the ConfigMgr DB. Thus, if you have any custom reports, make sure you export those so you can re-import them.

    Note that this is the same answer as given in http://social.technet.microsoft.com/Forums/en-US/a1558842-cdf5-4e5f-8f10-d660e96eae1b/migration-sql-for-sccm-2012#81a5d010-910c-459f-acf6-cd3e4e035bec.


    Jason | http://blog.configmgrftw.com

    • Marked as answer by JOSE ANDERSON Monday, June 24, 2013 2:17 AM
    Saturday, June 22, 2013 5:29 PM
  • Nope, From a CM12 perspective nothing is really stored in the SSRS db. You still need to back up your custom reports, the easiest way to do this is to export them for the old SSRS site and import them on the new site.. Keep in mind that you will like have to reset the data source links.


    http://www.enhansoft.com/

    • Marked as answer by JOSE ANDERSON Monday, June 24, 2013 2:17 AM
    Saturday, June 22, 2013 5:40 PM

All replies

  • There is only 1 way to do this.. Create a new RP and remove the old one.. But keep in mind that this will NOT move any custom reports. You will need to backup the RDL and move them to the new server.

    http://www.enhansoft.com/

    • Marked as answer by JOSE ANDERSON Monday, June 24, 2013 2:17 AM
    Saturday, June 22, 2013 1:02 AM
  • It is not necessary to backup the Report DB, and restore on the new server?

    José Anderson Santiago Microsoft Community Contributor - MCP - MCDST - MCSA - MCTS - MCITP - MCT / Se a resposta foi útil classifique.

    Saturday, June 22, 2013 1:34 AM
  • Why would it be?

    The reporting DB only contain information about reporting specific things like the reports and subscriptions. The data displayed in the reports is always pulled from the ConfigMgr DB. Thus, if you have any custom reports, make sure you export those so you can re-import them.

    Note that this is the same answer as given in http://social.technet.microsoft.com/Forums/en-US/a1558842-cdf5-4e5f-8f10-d660e96eae1b/migration-sql-for-sccm-2012#81a5d010-910c-459f-acf6-cd3e4e035bec.


    Jason | http://blog.configmgrftw.com

    • Marked as answer by JOSE ANDERSON Monday, June 24, 2013 2:17 AM
    Saturday, June 22, 2013 5:29 PM
  • Nope, From a CM12 perspective nothing is really stored in the SSRS db. You still need to back up your custom reports, the easiest way to do this is to export them for the old SSRS site and import them on the new site.. Keep in mind that you will like have to reset the data source links.


    http://www.enhansoft.com/

    • Marked as answer by JOSE ANDERSON Monday, June 24, 2013 2:17 AM
    Saturday, June 22, 2013 5:40 PM
  • Jason -

    If my PFE is advising to backup and restore the SSRS database could you elaborate on why you think this is a bad idea?

    He is suggesting we follow this procedure:
    https://blogs.technet.microsoft.com/configurationmgr/2013/04/02/how-to-move-the-configmgr-2012-site-database-to-a-new-sql-server/

    Will


    Will

    Tuesday, July 26, 2016 6:55 PM
  • It's not a bad idea necessarily. All I said is that is that the SSRS DB itself doesn't contain anything ConfigMgr specific except custom reports and subscriptions -- there is *no* actual data in the SSRS DB. Thus, if you don't have either of these (custom reports or subscriptions), don't care about them, or have them backed up in another way, backing up the SSRS DB is unnecessary and provides no real benefit.

    Jason | http://blog.configmgrftw.com | @jasonsandys

    Tuesday, July 26, 2016 7:25 PM
  • Ok - thanks. We do have hundreds of custom reports and linked server connections and custom data sources. Our SQL DBA type guy is really terrified about having to modify/edit/import all of those all over again. Backing up and restoring the database should avoid that... I hope.

    Will

    Tuesday, July 26, 2016 7:31 PM
  • There are scripts out there to easily export and import reports if needed.

    Subscriptions are painful though because they are only exposed to the user that created them. I *think* I found a script once that will help or do it though.

    But ultimately, if your are moving to a new SSRS instance, then a simple backup and restore of the DB is easiest.


    Jason | http://blog.configmgrftw.com | @jasonsandys

    Tuesday, July 26, 2016 8:06 PM
  • Ok - thanks. We do have hundreds of custom reports and linked server connections and custom data sources. Our SQL DBA type guy is really terrified about having to modify/edit/import all of those all over again. Backing up and restoring the database should avoid that... I hope

    Keep in mind that NONE of the Linked servers or custom data sources (depending on how they where created) will get migrated even if you backup and restore just the SSRS db.

    Linked server is a SQL instance item not a SSRS db item. Same might be true for custom data sources.


    Garth Jones

    Blog: http://www.enhansoft.com/blog Old Blog: http://smsug.ca/blogs/garth_jones/default.aspx

    Twitter: @GarthMJ Book: System Center Configuration Manager Reporting Unleased

    Tuesday, July 26, 2016 8:54 PM
  • Jason,

    Is there a script to export and import report Subscriptions?

    A simple backup/restore of the DB, I'm guessing this only applies between same version of SQL RS?

    Thanks,
    WiM

    Monday, August 29, 2016 8:20 AM
  • Not to my knowledge. That's a question for an SSRS forum though as it's not truly a ConfigMgr item.

    You should be able to restore an older SSRS DB backup to a newer version. Once again though, that's really a better question for an SSRS forum.


    Jason | http://blog.configmgrftw.com | @jasonsandys

    Monday, August 29, 2016 9:43 PM