...Because someone's gotta tell the story...


To return to the main Blog List, click Full Blog Listing.


SQL Reporting

Migrating a SRS report in 21 easy steps

Tuesday, October 29, 2013 in Technical Articles (Views: 3269)
Yes, this couldn't be much more painful, but for anyone looking to do this... In my scenario, I was moving SRS from SQL 2008 to SQL 2008 R2. Of course, 21 easy steps, give or take the ones I condensed. I won't be teaching you how to browse for, and double click a file.

This is specific to SCCM, but would work for other reports. One thing to note is that report migration is not supported, especially with direct reads from the database as part of the query. If you're using views, Microsoft answer to this is "we don't support it, but try it, it may or may not work".

Hope this is helpful to someone else.

1. Open a browser to both the SCCM 2007 and 2012 SQL Reporting Services Site. You’ll want to use the full FQDN and insure the site is trusted (and should be, if it's in your organization.
1a. For 2007:
1b. For 2012:
1c. Note: for a named instance, it's name)
2. Go to the SCCM 2007 SQL Reporting Services Site
3. Browse to the folder you want to export the report from
4. Click “Show Details” on the top right if you can’t see the edit button
5. Click Edit
6. Under Report Definition, click Edit again (looks like a hyperlink)
7. The file name will default to the report name with a RDL extension
8. Click Save
9. You’ll be asked to save the file, I put everything on the local disk in a folder that resembles the SRS structure
10. Click Close
11. Go to the SCCM 2012 SQL Reporting Services Site
12. Navigate to the report folder you want to upload to, if it doesn't exist (yet), create it.
13. Click Upload File
14. Browse to the file, and click OK to upload
15. Next, we need to change the datasource. Click the down arrow to the side of the new report, and click Manage
16. Click Data Sources on the left pane
17. Click Browse on shared data source
18. Data source is under ConfigMgr_(sitecode) at the bottom. Looks like a GUID.
19. Click OK
20. Click Apply
21. Test the report

...Rinse and repeat.


Related Blogs You May Be Interested In:

To leave a comment, please log in and/or register.