0

We've been developing reports in a dev environment for a few months and we're ready for a data migration and to point these reports to a new location.

What I need to do is change the data source for all of these reports without having to go to each report, change the data source, and re-deploy the reports.

I'm thinking I could be able to just change the current data source from the SSRS portal to point to the new location, but I would still need to touch each report and update them in source control.

I also came across a page for the RS.exe utility here. Not sure if that is going to do what I'm looking for.

Is there a best practice for this or is touching each report the only way to accomplish what I'm looking for?

jdids
  • 561
  • 1
  • 7
  • 22

1 Answers1

0

In order to avoid manually configuring individual Data Sources, you will either have to use an existing 3rd party tool or create one yourself that wraps the reporting services api.

I have two suggestions that might not be useful now, since you are ready to deploy, however, they might prove useful in future report development.

  1. Use Shared Data Sources. In your reports, configure each Data Set to point to one Shared Data Source. This would allow you to configure the connection information once per instance.

  2. Use a dynamic connection string expression for your report Data Source configuration.

Ross Bush
  • 14,648
  • 2
  • 32
  • 55
  • You are right, I'm too in the weeds. We already utilize the Shared Data Sources and dynamic connections for all solutions except this one :) Looks like I'm going to have to manually touch each report and deploy. Appreciate the response – jdids Nov 07 '18 at 16:21