June 7, 2011 at 7:25 pm
In the Report Manager, I create folders but need to move the rds and rdl files I created manually. But I can't figure out where the folders are so I can move the files.
I need to move them from my development server to my production server and need to do it by hand.
Thanks,
Tom
June 7, 2011 at 8:29 pm
They are stored in the database - not in the file system.
Your options are:
1) Use BIDS and deploy to the new system
2) Use a tool that will move it for you.
There is a tool available here: http://www.sqldbatips.com/showarticle.asp?ID=62
If you have to do this 'manually' without being able to use the above tool, then I would recommend the following:
From Report Manager - list the folder/reports in detail mode. From detail mode, select the option to edit the report properties. On that page, you have an option to edit/update the report. Select the option to edit - this will allow you to save the report (rdl) file to the file system.
Once you have all of the reports in a folder on the file system, open BIDS and create a new project. In that project, add existing item - from the folder you created to hold the RDL files. Repeat until you have added all reports.
Configure the project to deploy to the new report server and deploy.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply