Post reply

SSRS 2012 - Repalce Datasource name in all reports

  • March 17, 2015 at 3:45 am

    #295964

    About 200 reports user their own data sources. I restored 2008 Reportdb's in 2012 server. Datasource has to be changed to point tonew server.

    1. Is there an easy way to achieve this?

    2. Also, how to check if my 200 reports got upgraded to 2021

  • March 17, 2015 at 5:39 am

    #1784456

    watching this post for a better way; i couldn't figure out a way to cleanly edit a report programmaticly to change the datasourc.e

    when i cleaned up this same issue(2005 to 2008R2, same thing though), i had to edit all the reports in BIDS and change them to use a best practice shared data source.

    That was a pain.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • March 17, 2015 at 6:05 am

    #1784464

    Can we change in Catalog table? Is ther no other way other than modifying all the 200 reports?

Viewing 3 posts - 1 through 2 (of 2 total)

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